Urgent - Reorganising Data

  • Thread starter Thread starter Michael
  • Start date Start date
M

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
 
You could probably get to this with a pivot table, but I'm not sure that's
the solution you are looking for.
 
Back
Top