Splitting multiple rows into multiple columns without the use of VBA

Question

I know there's already questions and answers out there regarding what I'm asking today but they are to specific to the person who's asking the questions and I can't use the answers for my question...

I have a database that goes like this:

   A

1  Name

2  Email

3  Name

4  Email

But I need it to go like this

...A..................B

Name..........Email

(IGNORE FULL STOPS)

How can I do this without using a VBA but rather a shortcut of some sort?

To clarify, do you want row 1 to go Name...Email...Name...Email, or do you want column A to have the names and column B to have the Email? If you want the latter and have no spaces in your datablock then Gary's solution below should be fine. — Grade 'Eh' Bacon
– Grade 'Eh' Bacon, Commented Jul 22, 2015 at 13:09

Grade 'Eh' Bacon · Accepted Answer · 2015-07-22 12:58:48Z

1

CTRL + C
ALT then H then V then S then E.

This is the keyboard command to copy a range of values and paste them in a Transposition (shift the X axis and Y axis).

answered Jul 22, 2015 at 12:58

Grade 'Eh' Bacon

3,8534 gold badges26 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Chelsea Owen Over a year ago

Did nothing. Got a VBA instead?

Chelsea Owen Over a year ago

I know I said no VBA but I understand them better so

Grade 'Eh' Bacon Over a year ago

If you are unable to copy and paste it is not advisable to use VBA code you pulled from the internet.

Gary's Student · Accepted Answer · 2015-07-22 13:03:19Z

1

With data in column A, in B1 enter:

=INDEX(A:A,ROW()*2-1)

and copy down. In C1 enter:

=INDEX(A:A,ROW()*2)

and copy down:

answered Jul 22, 2015 at 13:03

Gary's Student

96.9k10 gold badges66 silver badges104 bronze badges

Collectives™ on Stack Overflow

Splitting multiple rows into multiple columns without the use of VBA

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related