New
#1
Excel Macro to move columns to 1 row after each other.
I was hoping someone could help me write or find a macro that would take two columns and move it to column A under the previous data and repeat for all columns. Basically user information is located in pairs of columns (typeofvalue, value). So column A and B are for user1, column C and D are user2, column E and F are user3, etc. Bonus if I could have a space in between each once moved.
Current:
Desired:HTML Code:A B C D User1First User1Last User2First User2Last User1ValueTypeA1 User1ValueB1 User2ValueTypeA1 User2ValueB1 User1ValueTypeA2 User1ValueB2 User2ValueTypeA1 User2ValueB1
Each user has 47 rows of "values", for the example I just did two rows worth.HTML Code:A B User1First User1Last User1ValueTypeA1 User1ValueB1 User1ValueTypeA2 User1ValueB2 SPACE/EMPTY ROW User2First User2Last User2ValueTypeA1 User2ValueB1 User2ValueTypeA1 User2ValueB1