| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
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 -- Regards, Peo Sjoblom "DHM" <(E-Mail Removed)> wrote in message news  F7BDEE2-A5CB-44AF-9B5F-(E-Mail Removed)...> 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 |
|
|
|
|
|||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Convert Columns to Rows and insert into another table based on valuesin columns | Gurvinder | Microsoft Access Form Coding | 7 | 25th Nov 2008 10:03 PM |
| Convert Columns to Rows and insert into another table based on valuesin columns | Gurvinder | Microsoft Access Queries | 0 | 24th Nov 2008 09:00 PM |
| Convert columns to rows: create duplicate rows based on column val | =?Utf-8?B?Q2FycmllUg==?= | Microsoft Access | 3 | 30th Aug 2006 07:07 PM |
| to convert columns to rows having mulit independent group columns | =?Utf-8?B?UXVhY3k=?= | Microsoft Excel Worksheet Functions | 1 | 22nd Aug 2006 11:20 PM |
| to convert columns to rows having mulit independent group columns | =?Utf-8?B?UXVhY3k=?= | Microsoft Excel Worksheet Functions | 0 | 22nd Aug 2006 08:59 PM |
