| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert columns to rows
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert columns to rows
Checkout the TRANSPOSE function
|
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert columns to rows
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? "DHM" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert columns to rows
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:A 1)-7) copy across 7 columns and then copy down -- Regards, Peo Sjoblom "DHM" wrote in message ... 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? "DHM" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert columns to rows
=OFFSET($A$1,COLUMNS($A1:A1)-1+(ROWS($1:1)-1)*6,0)
"DHM" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert rows to columns | Excel Worksheet Functions | |||
| Convert columns to rows | Excel Worksheet Functions | |||
| to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
| Convert rows to Columns | Excel Worksheet Functions | |||
| Can I convert columns to rows? | Excel Discussion (Misc queries) | |||
Hybrid Mode
