Hello friends, I would like some help in formatting an excel sheet. I have tried multiple scripts from the site and none of them seem to work. If I missed some I apologize. The worksheet starts in Column A but the unique ID is way over in Column X and the additional attendees are in separate rows in the column next to it, which is column Y. If the additional attendees corresponding to the ID is blank then we would like to keep it that way, since there are no additional attendees. When there are additional attendees, we would like them to be displayed in the same row as the ID - separated by commas. The additional attendees that are common to the ID are separated by rows. The xls starts in column A.
I have data in the following format:
Col X Col Y
<tbody>
</tbody>
Desired Result
<tbody>
</tbody>
The additional attendees need to be in one row. I cannot show it here because of the formatting.
Thank you for your help
I have data in the following format:
Col X Col Y
| ID | Additional Attendees |
| 6b2a75bb-6693-4ce9-a06c-01b0dc2c56be --------------------------------------------- | |
| cfbfe9f6-ef4f-45ff-9c74-0476cf9cdff0 --------------------------------------------- | |
| dea2be44-32bb-428b-b087-06b478afeff0 ------------------------------------------ | Dave Smith |
| Drew Barrymore | |
| Dwight Hall | |
| Elijah Wood --------------- | |
| Bjorn Borg | |
| Ivan Lendl | |
| John Mcenroe | |
| 82e66e81-8660-4c60-be59-0881e3d19395 ------------------------------------------ | Mats Wilander |
| Pete Sampras | |
| Roger Federer --------------------- | |
| Nick Compton | |
| Dave Mcgill | |
| 51bcf6e9-72c6-48cd-a3a1-08f7cf4893bd ----------------------------------------------- | Sherry Price |
| Gwenyth Paltrow ----------------- | |
| Tiffany Taylor | |
| 24e7cbce-5d3e-4a0c-bcad-0a3d413e466e ------------------------------------------- | ----------------- |
| 4d58a286-bb2d-4c39-969b-0c978a7d262a --------------------------------------------- | ------------------ |
| 0cd50c24-c382-4538-a461-0c9ffe113e3f ------------------------------------------- | ----------------- |
| 1a860b9a-4d0b-4d01-9423-0fd608447ee2 ----------------------------------------------- | Gigi Baker --------------------- |
| 8ad27d4d-2e21-47c1-8eef-12b3b282933e ---------------------------------------------- | ------------------------ |
| 6e9039cd-e7d4-4638-8654-1355b0b9a893 ----------------------------------------------- | Sue Bergstrom |
| Patty Holeman ----------------- |
<tbody>
</tbody>
Desired Result
| ID | Additional Attendees |
| 6b2a75bb-6693-4ce9-a06c-01b0dc2c56be --------------------------------------------- | ----------------------- |
| cfbfe9f6-ef4f-45ff-9c74-0476cf9cdff0 --------------------------------------------- -- | |
| dea2be44-32bb-428b-b087-06b478afeff0 ------------------------------------------ | Dave Smith, Drew Barrymore, Dwight Hall, Elijah Wood |
| --------------- | |
| Bjorn Borg, Ivan Lendl, John Mcenroe, Mats Wilander, Pete Sampras, Roger Federer | |
| 82e66e81-8660-4c60-be59-0881e3d19395 ------------------------------------------ | |
| --------------------- | |
| Nick Compton, | |
| Dave Mcgill, | |
| 51bcf6e9-72c6-48cd-a3a1-08f7cf4893bd ----------------------------------------------- | Sherry Price, |
| Gwenyth Paltrow ----------------- | |
| Tiffany Taylor | |
| 24e7cbce-5d3e-4a0c-bcad-0a3d413e466e ------------------------------------------- | ----------------- |
| 4d58a286-bb2d-4c39-969b-0c978a7d262a --------------------------------------------- | ------------------ |
| 0cd50c24-c382-4538-a461-0c9ffe113e3f ------------------------------------------- | ----------------- |
| 1a860b9a-4d0b-4d01-9423-0fd608447ee2 ----------------------------------------------- | Gigi Baker --------------------- |
| 8ad27d4d-2e21-47c1-8eef-12b3b282933e ---------------------------------------------- | ------------------------ |
| 6e9039cd-e7d4-4638-8654-1355b0b9a893 ----------------------------------------------- | Sue Bergstrom, Patty Holeman |
| ----------------- |
<tbody>
</tbody>
The additional attendees need to be in one row. I cannot show it here because of the formatting.
Thank you for your help
