Transposing data in Excel

Question

In Column A I have a number. In Column B I have a name as well as data that should go in columns C and D.

How can I turn this:

what I have

into this:

what I need

?

Is First name supposed to be Abbruzzese Gabriele? Also do you mean row or column? — assylias, Mar 19, 2012 at 12:00
Can you provide your data more clear and understandable way? — Siva Charan, Mar 19, 2012 at 12:23

wilson · Accepted Answer · 2012-03-20 05:52:31Z

1

Assume: Every 3 rows of old record = 1 row of new record

answered Mar 20, 2012 at 5:52

wilson

5,0122 gold badges22 silver badges39 bronze badges

1

That's pure binary-minded information :D You win.
– Pitto
Mar 20, 2012 at 10:21
1

I found another answer which is also good.
– wilson
Mar 21, 2012 at 2:12

Add a comment |

Raystafarian · Accepted Answer · 2012-03-19 13:22:30Z

1

copy - paste special - transpose

answered Mar 19, 2012 at 13:22

Raystafarian

21.7k12 gold badges62 silver badges90 bronze badges

it works but I shoud do it manually for a lot of rows...
– Pitto
Mar 19, 2012 at 17:22
record a macro? Is it always the same spacing?
– Raystafarian
Mar 19, 2012 at 18:39
Might not fit the use case which the OP asked about, but it certainly fits the title of this question, and as such was verys useful to me.
– MvG
Jun 1, 2013 at 19:20

Add a comment |

2 Answers 2