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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top