Hi All,
This is my first post however i have been using the forum for a while, unfortunately i cannot find an answer to this particular problem.
I have exported data from an access database. There is a one-to-many relationship between a clients details and the clients plans.Therefore the clients details are duplicated whilst the plans are unique per row. I would idealy like each plan on the same row. Below is an example of my current data set;
<tbody>
</tbody>
Below would be my desired outcome;
<tbody>
</tbody>
Any help would be greatly appreciated, the simpler the better!
Kind Regards,
Chris
This is my first post however i have been using the forum for a while, unfortunately i cannot find an answer to this particular problem.
I have exported data from an access database. There is a one-to-many relationship between a clients details and the clients plans.Therefore the clients details are duplicated whilst the plans are unique per row. I would idealy like each plan on the same row. Below is an example of my current data set;
Name: | Address: | Plan | |
Sam Tarly | Address 1 | Plan A | |
Sam Tarly | Address 1 | Plan B | |
John Snow | Address 2 | Plan A | |
Arya Stark | Address 3 | Plan B | |
Arya Stark | Address 3 | Plan C |
<tbody>
</tbody>
Below would be my desired outcome;
Sam Tarly | Address 1 | Plan A | Plan B |
John Snow | Address 2 | Plan A | |
Arya Stark | Address 3 | Plan B | Plan C |
<tbody>
</tbody>
Any help would be greatly appreciated, the simpler the better!
Kind Regards,
Chris