Urgent - Reorganising Data

[Michael]

Hello,
I have flat file which comes from a database however some of the information
is exported incorrectly. I need to find a solution as this is a major problem
that I didn'y know the d/b had issues with.
When I export the information it comes as

Unique ID Surname Firstname Event Notes
52 Bloggs Joe Museum Trip Diabetic
52 Bloggs Joe Zoo Trip Diabetic
etc

However I need the information to display as

Unique ID Surname Firstname Museum Trip Zoo Trip Notes
52 Bloggs Joe Yes
Yes Diabetic
56 Smith John
Yes

Any help would really be appreciated

kind regards

Michael

 

[Barb Reinhardt]

You could probably get to this with a pivot table, but I'm not sure that's
the solution you are looking for.