Combine multi-value rows into a single row based on a Primary Key

Hello,

I am hoping to get some help with an issue. I've extracted a rather large file with 16,000 service desk tickets with all related fields. Some fields are many to one meaning this file of 16,000 tickets turns out to be about 160,000 rows. I need to be able to semi-colon separate the fields with multiple values to create 1 row per ticket while not losing any information. I have attached a file with a tab for the current file and desired outcome (please notice that the fields with "Multi" in row 1 are the ones which need to be combined):

Test File.xlsx

I am hoping to make this process repeatable so any help would be greatly appreciated.

Thank you in advance!

Please see attached

Thank you AB33! Are you using the column numbers to identify which columns needed to have their values semi-colon separated?

I am using column A. My result is the same as yours one as per the attached.

Right, I really appreciate the solution. I was just curious how it knows not to semi-colon separate the values in Column D?

check sheet1 tab

Because you have not asked as per the attached. If you want I can add to the code.

Added column D

Thank you so much for the clarification and the solution!

You are welcome!
Could you please now close this thread as solved? Go in to the top right-hand side of this page, choose, "Thread Tools", select, solved from the drop down menu.