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, 10 views)

Maybe like the attached.

MJ.xlsx

[QUOTE=xor;135974]Maybe like the attached.

Many Thanks,
I am trying to figure the formula. Will come back with queries

Best Regards
Manish