Forum Discussion
Append columns of the same table
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 proj...
Hi Anonymous ,
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
serpiva64
Solution Sage
Solution SageHi,
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 !
Phenomenal, thank you!