Hello,
I have excel spread sheet with each individual (Client_ID) attending a program on different dates. It is in the form of vertical data. I am trying to make it horizontal. My problem is each client_ID is linked to two programs in this case. So when I try to convert vertical data into horizontal it takes its uppermost event name and does not consider the second one.
Attached please find the sample of what I am trying to do. All the data is in vertical form (left three columns). On upper right side, please see what I have done so far. Below (highlighted in pink) is the way I need it.
Thank you so much for the help.
Ajang
Sorry, I forgot to attach the file before.
Thank you Pike
Bookmarks