Thread
:
Look-up and Merge
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Michael D[_2_]
external usenet poster
Posts: 1
Look-up and Merge
I have the following data:
A B
Inv No. Serial No.
0001 ABC
0001 DEF
0001 GHI
0002 JKL
0002 MNO
0002 PQR
and need to come back to this:
Inv No. Serial No
0001 ABC, DEF, GHI
0002 JKL, MNO, PQR
Would anyone be able to help me out
Reply With Quote
Michael D[_2_]
View Public Profile
Find all posts by Michael D[_2_]