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!