Hi,
I am working with more than 50k data base(Ac No.) using Excel 2007. Some of the "Ac No." has more than 1 "Name", I wish to have all the names belongs to the same "Ac No." only shown in 1 row:
Example:
Ac No. Name
1 Alvin Ltd
1 Bolton SD
1 Terabase td
2 Yoyo SD
2 Get Ltd
3 Wonder Ltd
3 Vase SDH
3 Growth Ltd
4 Vege SDH
Expected Result:
Ac No. Name 1 Name 2 Name 3
1 Alvin Ltd Bolton SD Terabase td
2 Yoyo SD Get Ltd
3 Wonder Ltd Vase SDH Growth Ltd
4 Vege SDH
I have tried Pivot Table not it cant provide the result i wanted. Is there any Excel Formular can handle this type of data conversion? I am not good in VB and Marco at all.
Your kind assistance is very much appreciated.
Thanks
Iris
Bookmarks