VBA To Concatenate Data

[jo15765]

If this can be done using an excel formula, I'm good with that as well, but I think...VBA is the easiest way. I have a spreadsheet with about 2,000 rows in it that houses data in columns A & B that looks like this

Name	Store
Abel	        Red
	        Green
Bill	        Purple
Charles	Red
	        White
Dean	        Green
	        Red

And the format I need the data in is. just like this

Name	Store 1	Store 2
Abel	        Red	        Green
Bill	        Purple	
Charles	Red	        White
Dean	       Green	Red

How would I do this?


EDIT --- not sure why my formatting gets all jacked up when I post this. Essentially how I have the data has name in column A and multiple stores in Column B. So one employee could have 2 rows with 2 different stores listed. I need the data for each employee to have ONE row.