Solved Excel Macro to move columns to 1 row after each other.

[brubakes]

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:

A			B			C			D		
User1First		User1Last		User2First		User2Last
User1ValueTypeA1	User1ValueB1		User2ValueTypeA1	User2ValueB1
User1ValueTypeA2	User1ValueB2		User2ValueTypeA1	User2ValueB1

Desired:

A			B
User1First		User1Last
User1ValueTypeA1	User1ValueB1
User1ValueTypeA2 	User1ValueB2

SPACE/EMPTY ROW

User2First		User2Last
User2ValueTypeA1	User2ValueB1
User2ValueTypeA1	User2ValueB1

Each user has 47 rows of "values", for the example I just did two rows worth.

 

[Dude]

I did a quick google and found this. It worked for you?

Excel macro to move columns to 1 row after each other

 

[brubakes]

I did a quick google and found this. It worked for you?

Excel macro to move columns to 1 row after each other

Yes it did, thank you for checking in. I've marked this thread as solved.