How do I transpose data in columns to rows?
If the data is:
Joe
some city
some state
Bob
no city
no state
and I use Paste Special ยป Transpose, I get
Joe some city some state Bob no city no state
What I want is:
Joe some city some state
Bob no city no state
I do not know VBA.
Best Answer
We're gonna learn you some VBA this morning and you're going to feel good about that! Put on your rocket boots and get ready to sail!
This macro will do it for you if it's all in column A
Hit Alt + F11 to bring up VBA editor. Right click
insert - module
. Paste the code below in the module and to godebug - compile project
and hit F5 to run it. Easy breezy.Easy as 1, 2, 3:
1.
![enter image description here](https://i.stack.imgur.com/bm1XS.png)
![enter image description here](https://i.stack.imgur.com/VnCfj.png)
2.
3.
See now that wasn't difficult or intimidating, was it? And now you have a trick up your sleeve! Learning is great fun!