I have a spreadsheet with 2000+ consecutively filled rows. Each row has multiple columns with data (B:H).
I would like to use the value in e.g. B1 and paste the corresponding row 1 data into row 2. I would like to do this for all data.
As an example, now a row reads (comma meaning new column) :
Grill of Arabia, Schulterblatt 35, 20357, Hamburg, (Sternschanze), Tel.: xxx
Isis, Loogestieg 2, 20249, Hamburg, (Eppendorf), Tel.: xxx
etc.
I want it to read:
Grill of Arabia
Schulterblatt 35, 20357, Hamburg, (Sternschanze), Tel.: xxx
Isis
Loogestieg 2, 20249, Hamburg, (Eppendorf), Tel.: xxx
I assume I would need a macro for this but I am very new to using macros.
Can anyone help?
Thanks!
Bookmarks