Hey everyone,
I've been having difficulty figuring this out; hoping someone can help.
Values in column A will be unique in new sheet but Column B can have multiple values for the unique value in A.
Matching Column A and B, then looking up the data in Column C to transpose in another file/sheet.
I have the data in this format in one file/sheet.
Column A Column B Column C
1 A AN01
1 A AN02
1 A AN03
1 B AN04
1 B AN05
1 B AN06
2 C AN01
2 C AN02
2 C AN03
2 C AN04
2 C AN05
2 C AN06
3 D AN01
3 D AN02
3 D AN03
3 E AN04
3 E AN05
3 E AN06
I want to do a vlookup from another file or sheet and transpose like this
Column A Column B Column C Column D Column E Column F Column G Column H
1 A AN01 AN02 AN03
1 B AN04 AN05 AN06
2 C AN01 AN02 AN03 AN04 AN05 AN06
3 D AN01 AN02 AN03
3 E AN04 AN05 AN06
Thanks
Khan
Bookmarks