I have looked all over and short of manually highlighting and copy+pasting each column, I can't find a way to do this.
I have a list of names where some cells have multiple names per cell separated by a semicolon. I know I can use Text to Column to spread these out, but what I'm wanting is only one name per cell and any additional to be added to the end of the column in their own cells. This will be a table as well.
Everything I can find is either wanting me to use Text to Columns thinking I want the opposite of what I'm asking, or Concatenate, also not what I'm wanting.
I have a list of names where some cells have multiple names per cell separated by a semicolon. I know I can use Text to Column to spread these out, but what I'm wanting is only one name per cell and any additional to be added to the end of the column in their own cells. This will be a table as well.
Everything I can find is either wanting me to use Text to Columns thinking I want the opposite of what I'm asking, or Concatenate, also not what I'm wanting.