In the attachment I have a source table of first name names, second name
I need the second name to come in another line
I set a column split according to a comma
But I got the second name in another column.
How do I move the name to another line -
And get all the data of the first name also for the row of the second name?
I was able to change this in the small table, attached to the patch
The problem is I can not apply this in a larger table -
Attached here is a large table - Big Data
In the original file column J
There are many names with commas
In Issue 1 - The Yellow K L Columns I Need to Change -
That the name found in column L
Will become a row in column K
How do you do that?
Thanks for the professional answer !!
Leah
Hi Lea,
I'm confused. You ask that names be split so that first name and last name are on separate rows. But the example you provide in Invert-columns-into-rows-1.xlsx has the first names repeated 'Gal, Moshe, Yakov'. The last names are not in the table at all? And what's the 3rd column for in the same file?
So what is it that you are actually trying to do?
Why would you want to split a name in such a way and create what appears to be a duplicate record? I don't understand the purpose of doing this.
Big-Data.xlsx has no names in Col L.
Regards
Phil
So please refer only to the Big Data file
The Source sheet in column J has cells that have 2 names in the cell
Full name, full name
I need the second full name to move to a separate row with all the data in the same row
How can this be done?
Thanks for the professional answer
Leah
Hi Lea,
In the Split Column by Delimiter dialog box under Advanced Options there is an option to split it into Rows.
Mynda
