CODEWITHSUNDEEP
excelexcel-formula
ASH
ASH

Reputation: 20302

How can I transpose a data set by doing a double lookup?

This is what I have now.

enter image description here

This is the way I want to see the data.

enter image description here

It's a pretty small data set. I'm trying to figure out a way to transpose the data based on a double lookup. I think it will require some kind of vlookup and index/match, or some kind of row/column offset. I tried a few ideas, but can't seem to get this resolved.

Upvotes: 1

Views: 70

Answers (1)

Kresimir L.
Kresimir L.

Reputation: 2441

You can achieve this with a helper column. If you have your data in Column A:B, enter this formula =A2&B2 in cell C2 and drag it to the bottom. then if your new table start at cell F1, please enter this formula =IFERROR(INDEX($B$2:$B$1700,MATCH($F2&G$1,$C$2:$C$1700,0),IF(FIND(G$1,$C2,1)>0,1,0)),"") in Cell G2 and drag it beneath whole table.

enter image description here

Upvotes: 1

Related Questions