rduffieldc
New Member
- Joined
- Apr 30, 2024
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I have a list of appointments in a spreadsheet. Some columns contain the same location of the appointment (ie 'hospital 1' is the header for column B & C). I'm trying to #1, move all of the appointments into one column, and #2, create/insert a new column for the associated hospital name (column header). Here is an example of what the sheet looks like:
And here is what I would like to end up with:
Any help you could provide would be much appreciated!!!
Hospital 1 | Hospital 1 | Hospital 2 | Hospital 2 | Hospital 3 | Hospital 3 | |
Person1 | Monday | |||||
Person2 | Tuesday | |||||
Person3 | Wednesday | |||||
Person4 | Tuesday | |||||
Person5 | Friday | |||||
Person6 | Monday | |||||
Person7 | Tuesday | |||||
Person8 | Wednesday | |||||
Person9 | Thursday | |||||
Person10 | Monday | |||||
Person11 | Monday | |||||
Person12 | Tuesday |
And here is what I would like to end up with:
Hospital | Appointment | |
Person1 | Hospital 1 | Monday |
Person2 | Hospital 1 | Tuesday |
Person3 | Hospital 1 | Wednesday |
Person4 | Hospital 1 | Tuesday |
Person5 | Hospital 3 | Friday |
Person6 | Hospital 3 | Monday |
Person7 | Hospital 3 | Tuesday |
Person8 | Hospital 2 | Wednesday |
Person9 | Hospital 2 | Thursday |
Person10 | Hospital 2 | Monday |
Person11 | Hospital 1 | Monday |
Person12 | Hospital 1 | Tuesday |
Any help you could provide would be much appreciated!!!