consolidate the data in excel

[buddigars]

Hi Excel gurus,

I have the excel with more than 1000 rows in the below format
(column A) (column B)
manufacturer model
================================
MARUTI 1000GG
MARUTI 9400 KK
MARUTI 987600P
MARUTI 78678PP
HONDA 9999RST
HONDA 9875IWH
HONDA 98666UI
GEN MOTORS 7890000
GEN MOTORS 7890089

my final excel sheet should look like this. Based on the manufacturer the models should be consolidated and separated by comma in a single column. I found transpose function to group but doing manually for 1000+ rows is cumbersome. I would like to know if there is a way to do it with formulas or anything automatically

(column A) (column B)
manufacturer model
================================
MARUTI 1000GG,9400 KK,987600P,78678PP
HONDA 9999RST,9875IWH,98666UI
GEN MOTORS 7890000,7890089

Thank you all for looking into my post and helping me

[mehmetcik]

Easiest way is with a macro.

Please Login or Register  to view this content.