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
BA_Pete
Super User
Super UserHi 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
Thank you so much