Hi all, I have a table that looks like the below example. I want to be able to use an INDEX formula to transpose figures from this vertical data, to another (working out %) which is horizontal:
Table to INDEX:
<tbody>
</tbody>
Table to transpose to:
<tbody>
</tbody>
I am basically trying to work out percentages, for a much larger table that I am working on, and wish to copy the formula from left to right on each row of the blank cells int he transposed table.
So, think it is something like =INDEX(first table array), then look up 'Satisfied' and look at column 2, row 2. If I drag that formula right, I want it to look at the same array, but use the figure from column 2, row 3. Then column 2, row 4 etc.
Table to INDEX:
Satisfied | Neutral | Dissatisfied | |
Q1 | 222 | 13 | 10 |
Q2 | 172 | 10 | 8 |
Q3 | 82 | 6 | 7 |
Q4 | 107 | 7 | 4 |
Totals of each | 583 | 36 | 29 |
Overall Total | 648 |
<tbody>
</tbody>
Table to transpose to:
Q1 | Q2 | Q3 | Q4 | |
Satisfied % | ||||
Neutral % | ||||
Dissatisfied % |
<tbody>
</tbody>
I am basically trying to work out percentages, for a much larger table that I am working on, and wish to copy the formula from left to right on each row of the blank cells int he transposed table.
So, think it is something like =INDEX(first table array), then look up 'Satisfied' and look at column 2, row 2. If I drag that formula right, I want it to look at the same array, but use the figure from column 2, row 3. Then column 2, row 4 etc.