Help? Split table rows to columns.

**anos** · 07-03-2011, 07:58 AM

Hello,
can u help me?

I have a list with rows like this:
A B
1a
2a
3a
4a
5a
6a

and i want automatically turn into this:

A B
1a 2a
3a 4a
5a 6a

I have excel 2007, and i i'm new user.

THANX in advance.

(p.s. admins: hope i post it in the right category)

**Roger Govier** · 07-03-2011, 08:11 AM

Hi

Welcome to the forum

I assumed your data was starting in row 1 of column A.
In C1 enter
=INDEX($A:$A,((ROW()-2)*2)+2)
in D1 enter
=INDEX($A:$A,((ROW()-2)*2)+2)

copy down as far as required

**ConneXionLost** · 07-04-2011, 01:32 AM

Small correction to Roger's formulae:

assuming your data was starting in row 1 of column A.

In C1 enter:

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

in D1 enter:

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

Cheers,

**Roger Govier** · 07-04-2011, 03:24 AM

Originally Posted by ConneXionLost

Small correction to Roger's formulae:

assuming your data was starting in row 1 of column A.

In C1 enter:

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

in D1 enter:

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

Cheers,

Thank you. My bad

I had set it up with data starting in row 2 of a sheet, then foolishly told the OP to enter it in C1 and D1 rather than C2 and D2

Lucky somebody was wide awake!!

Thread: Help? Split table rows to columns.

Thread Tools

Rate This Thread

Display

Help? Split table rows to columns.

Re: Help? Split table rows to columns.

Re: Help? Split table rows to columns.

Re: Help? Split table rows to columns.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions