Transpose table from a questionnaire

[Jesse]

Hi all, I'm creating a questionnaire, which will be linked to a small dashboard. I'd need to transpose a table that maintains links to the original table. I've tried to many things! Here's a file that explains more and shows my plan so far.


I originally posted a related question here (http://chandoo.org/forums/topic/combining-paste-functions-paste-link-and-transpose). This is a better explanation of my needs.


Thanks in advance, happy Friday night


https://www.dropbox.com/s/yvvbg3b0qkijgzp/Transpose%20table%20problem.xlsx

 

[NARAYANK991]

Hi Jesse ,


You can do it using either formulae or VBA.


When you use formulae , you can refer to the table in the hidden control section , instead of referring to the original source data. For example , if you put in the following formula in cell V24 , it will do this.


=OFFSET($Z$5,COLUMN(V24)-COLUMN($V$24),ROW(V24)-ROW($V$24))


Narayan

 

[Jesse]

Wow, thank you! I feel enlightened (and a little lighter also). I really appreciate it