Hello,

I've been having trouble with a worksheet with roughly 2000 rows and 4
columns. The first column has a full list of names, the second column
a list of names (not full), the third and fourth columns with numerical
values. I need to align the first column with the 2nd, 3rd and 4th
column: here's an example:

Jane Joe 5 $10
Joe Mary 8 $9
John Steve 6 $20
Mary
Sara
Steve

I want it to turn out like this:

Jane
Joe Joe 5 $10
John
Mary Mary 8 $9
Sara
Steve Steve 6 $20

Is there any way to make this process either, because at this time, all
i'm doing is inserting blank rows, one by one.

Thank you in advance for your assistance!

John