I have following two columns of data in excel 2007:

`a 1 b 2 ... `

What I need to swap the view to:

`a b ... 1 2 ... `

I think there is way to do it in excel 2007. Is this possible?

I have following two columns of data in excel 2007:

`a 1 b 2 ... `

What I need to swap the view to:

`a b ... 1 2 ... `

I think there is way to do it in excel 2007. Is this possible?

**Replay**

No VBA programming necessary.

Just Copy, Paste Special, then check the "transpose" box.