convert columns to rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DHM - 29 Jun 2007 21:56 GMT

I have a groups of 6 cells that are in column A (A1, A2, A3, A4, A5,A6). I
want to change the 6 cells in column A to create new columns B1,C1,D1,E1,F1 &
G1. Then the second set of 6 cells in A (A7,A8,A9,A10,A11,A12) become
B2,C2,D2,E2,F2 & G2) and so on. I am using Excell 2007. Let me know if this
can be done

Reply to this Message

Piscator - 29 Jun 2007 22:22 GMT

Checkout the TRANSPOSE function

Reply to this Message

DHM - 29 Jun 2007 22:36 GMT

The transpose works for one goup but I need to transpose over 1000 groups. Is
there a way group each set of 6 cell then transpose?

> I have a groups of 6 cells that are in column A (A1, A2, A3, A4, A5,A6). I
> want to change the 6 cells in column A to create new columns B1,C1,D1,E1,F1 &
> G1. Then the second set of 6 cells in A (A7,A8,A9,A10,A11,A12) become
> B2,C2,D2,E2,F2 & G2) and so on. I am using Excell 2007. Let me know if this
> can be done

Reply to this Message

Peo Sjoblom - 29 Jun 2007 22:58 GMT

Assume that the values start in Sheet1!A1, insert a new sheet (or use
another sheet that is empty) and put this in A1

=INDEX(Sheet1!$A:$A,ROWS($A$1:A1)*7+COLUMNS($A$1:A1)-7)

copy across 7 columns and then copy down

Signature

Regards,

Peo Sjoblom

> The transpose works for one goup but I need to transpose over 1000 groups.
> Is
[quoted text clipped - 8 lines]
>> this
>> can be done

Reply to this Message

Teethless mama - 30 Jun 2007 02:52 GMT

=OFFSET($A$1,COLUMNS($A1:A1)-1+(ROWS($1:1)-1)*6,0)

Reply to this Message