Append columns of the same table

[eloomis]

I have a table like this:

ProjectID | Project Manager

12345        John Doe

67890        John Doe, Jane Doe

I need to have a column of single project managers, with their correlated project ID. So I split Project manager on comma delimiter and now I have two columns Project Manager.1 and Project Manager.2. How can I append Project Manager.2 to 1, retaining the projectID, and hopefully not generating a new query to be kind to my file size. Thank you!

[serpiva64]

Hi,

you have to split column by delimeter choosing split into rows

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !

[eloomis]

Phenomenal, thank you!

[BA_Pete · Accepted solution]

Hi @eloomis ,

When you split the [ProjectManager] column using the ", " delimiter, expand the advanced option in the split dialog and you'll see you can split the values to new rows, instead of columns:

Pete

[ramdasanudas]

Thank you so much

[eloomis]

Fantastic, thank you!