Hi,
I have been trying a formula to return row and column heading from table 1 including the cell value of the cell with value in it. I had been trying to follow this post : https://www.mrexcel.com/forum/excel...column-header-row-header-each-occurrence.html but can't seem to make it work. Can anyone help with a simpler Index/Vlookup formula.
here is my example, Table 1 to give something like that of Tabe 2:
<colgroup><col width="64" span="6" style="width: 48pt; text-align: center;"> </colgroup><tbody>
</tbody>
Thanks in advance
I have been trying a formula to return row and column heading from table 1 including the cell value of the cell with value in it. I had been trying to follow this post : https://www.mrexcel.com/forum/excel...column-header-row-header-each-occurrence.html but can't seem to make it work. Can anyone help with a simpler Index/Vlookup formula.
here is my example, Table 1 to give something like that of Tabe 2:
Table1 | |||||
Apple | Banana | Cake | Chips | ||
Alex | 1 | ||||
Brian | 2 | 1 | |||
Charlie | 3 | ||||
Dana | 1 | 2 | 1 | ||
Erica | 2 | ||||
Fred | 1 | ||||
Grace | 2 | ||||
(blank) | 1 | 1 | |||
Table2 | |||||
Alex | 1 | Banana | |||
Brian | 2 | Banana | |||
Brian | 1 | Chips | |||
Charlie | 3 | Apple | |||
Dana | 1 | Apple | |||
Dana | 2 | Cake | |||
Dana | 1 | Chips | |||
Erica | 2 | Chips | |||
Fred | 1 | Apple | |||
Grace | 2 | Banana | |||
(blank) | 1 | Apple | |||
(blank) | 1 | Cake |
<colgroup><col width="64" span="6" style="width: 48pt; text-align: center;"> </colgroup><tbody>
</tbody>
Thanks in advance