Delineate into new rows - advice please!

[TC_vii]

Hi folks,

I was hoping I might be able to ask for help - I am working with a large data set where each row has unique identifying information under separate columns (ie name, status etc) but there's also a column with multiple pieces of data separate by semi-colons. I need to delimit this cell into separate rows whilst carrying the unique identifying information into these newly created rows to allow for analysis via data model pivots.

What would be the best way to do this, would it be a VBA macro? If so, how would I go about creating it? I've never tried to create a VBA macro before so I'm a complete novice!

In case useful, examples attached of how the data looks now and how I would like it to look.

Thanks!

 

[Automatrix]

Power Query: Split Column (By Delimiter). Make sure the custom delimiter has a space after the semicolon.

 

[TC_vii]

Power Query: Split Column (By Delimiter). Make sure the custom delimiter has a space after the semicolon.

View attachment 87981

That has worked perfectly. Thank you! Have a great day