I have about 2.5 million rows in the format listed below. I was wondering if there was an easy way (in excel or access) to format them to the second example listed below.
So that if <column A> has multiple matching values all of their <column B> values could be moved to a single line.
100 BOB
100 JON
100 MARK
101 BOB
101 TIM
102 CHRIS
I would like to convert it to :
100 BOB JON MARK
101 BOB TIM
102 CHRIS
Bookmarks