Hi,

This is my first help post.


I have named Table 1 it has data arranged in rows and columns.
I want this data to be populated in Table 2 however the rows and columns are inter changed . The format of table 2 is changed though data is same as Table 1.
I have tried Vlookup ,Hlookup and index and match . Could not figure it out.
I have been struggling with this for a long time.
Attaching both tables for visualization purpose.
I need to get table 2 using formulas.
Hope you can Help.

Attached Files

MJ example.xlsx (10.9 KB, 12 views)