Table reformat

T

Twisty1980

Hello,

Using either Excel or Access I would like to try and format the following
data in an automated way:

Name | type
joe a
john b
joe b
jack c
joe c


shown as

name | type1 | type2 | type3......
john b
joe a b c
jack c

Tried manual formatting but its too slow for the size of file I will be
needing it for.

Any help would be very much appreciated

T
 
Top