Hi,
If someone can suggest a formula I would be very grateful!
I have an excel sheet I am trying to edit with over 500 rows of entries. I couldn't get an CSV file so I have copied it from a Word document so it split up the information into 2 rows.
I need to combine every second row into the row of the one above but keep them in seperate columns.
This is an example of what I am working with;
I need it to look like this;
Please any suggested are appreciated.
Thank you!
If someone can suggest a formula I would be very grateful!
I have an excel sheet I am trying to edit with over 500 rows of entries. I couldn't get an CSV file so I have copied it from a Word document so it split up the information into 2 rows.
I need to combine every second row into the row of the one above but keep them in seperate columns.
This is an example of what I am working with;

I need it to look like this;

Please any suggested are appreciated.
Thank you!