Wasn't sure how to title this, but I have data in multiple columns after doing a Text-to-column process. I need the first few columns (fields) copied to a new row for each one of the newly created columns from the text-to-column process.
A B C D E F G 1 Name1 City1 Nickname1 Address1 Address2 Address3 Address4 ... 2 Name2 City2 Nickname2 Address1 Address2 ...
What I want:
A B C D 1 Name1 City1 Nickname1 Address1 2 Name1 City1 Nickname1 Address2 3 Name1 City1 Nickname1 Address3 4 Name1 City1 Nickname1 Address4 5 Name2 City2 Nickname2 Address1 6 Name2 City2 Nickname2 Address2
Image instead of text since text isn't always pretty: Image of example instead of text