| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy only the 1st, 7th, 13th, 19th, 25th.....row only
I have information in col A. Every six rows (A1:A6, A7:A12.) belongs to the
item. As it was not an easy way to view the informations, I intended to move the informations across the columns, B1=A1, C1=A2, D1=A3, E1=A4........ B2=A7, C2=A8, D2=A9.. B3=A13, C3=A14.. tnks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy only the 1st, 7th, 13th, 19th, 25th.....row only
Enter this formula *anywhere*,
=INDEX($A:$A,COLUMNS($A:A)+6*ROWS($1:1)-6) Then copy across 6 columns, Then copy down as many rows as needed. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "vcff" wrote in message ... I have information in col A. Every six rows (A1:A6, A7:A12.) belongs to the item. As it was not an easy way to view the informations, I intended to move the informations across the columns, B1=A1, C1=A2, D1=A3, E1=A4........ B2=A7, C2=A8, D2=A9.. B3=A13, C3=A14.. tnks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy only the 1st, 7th, 13th, 19th, 25th.....row only
One way ..
In B1: =INDEX($A:$A,ROWS($1:1)*6-6+COLUMNS($A:A)) Copy B1 across to G1, fill down until zeros appear signalling exhaustion of data extracted from col A -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "vcff" wrote: I have information in col A. Every six rows (A1:A6, A7:A12.) belongs to the item. As it was not an easy way to view the informations, I intended to move the informations across the columns, B1=A1, C1=A2, D1=A3, E1=A4........ B2=A7, C2=A8, D2=A9.. B3=A13, C3=A14.. tnks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy only the 1st, 7th, 13th, 19th, 25th.....row only
Thanks Max
That was what I needed "Max" wrote: One way .. In B1: =INDEX($A:$A,ROWS($1:1)*6-6+COLUMNS($A:A)) Copy B1 across to G1, fill down until zeros appear signalling exhaustion of data extracted from col A -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "vcff" wrote: I have information in col A. Every six rows (A1:A6, A7:A12.) belongs to the item. As it was not an easy way to view the informations, I intended to move the informations across the columns, B1=A1, C1=A2, D1=A3, E1=A4........ B2=A7, C2=A8, D2=A9.. B3=A13, C3=A14.. tnks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy only the 1st, 7th, 13th, 19th, 25th.....row only
No prob, welcome.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "vcff" wrote in message ... Thanks Max That was what I needed |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy only the 1st, 7th, 13th, 19th, 25th.....row only
tnks
It helps to solve my problem. "RagDyer" wrote: Enter this formula *anywhere*, =INDEX($A:$A,COLUMNS($A:A)+6*ROWS($1:1)-6) Then copy across 6 columns, Then copy down as many rows as needed. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "vcff" wrote in message ... I have information in col A. Every six rows (A1:A6, A7:A12.) belongs to the item. As it was not an easy way to view the informations, I intended to move the informations across the columns, B1=A1, C1=A2, D1=A3, E1=A4........ B2=A7, C2=A8, D2=A9.. B3=A13, C3=A14.. tnks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy only the 1st, 7th, 13th, 19th, 25th.....row only
Appreciate the feed-back.
-- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "vcff" wrote in message ... tnks It helps to solve my problem. "RagDyer" wrote: Enter this formula *anywhere*, =INDEX($A:$A,COLUMNS($A:A)+6*ROWS($1:1)-6) Then copy across 6 columns, Then copy down as many rows as needed. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "vcff" wrote in message ... I have information in col A. Every six rows (A1:A6, A7:A12.) belongs to the item. As it was not an easy way to view the informations, I intended to move the informations across the columns, B1=A1, C1=A2, D1=A3, E1=A4........ B2=A7, C2=A8, D2=A9.. B3=A13, C3=A14.. tnks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I Calculate Check Digit for UPC A - the 13th warrior | Excel Discussion (Misc queries) | |||
| Problem with sorting 19th century dates | Excel Worksheet Functions | |||
| Sum function that add every 13th row... | Excel Discussion (Misc queries) | |||
| Find the date for monday prior to May 25th | Excel Worksheet Functions | |||
| Eliminating every 25th row | Excel Worksheet Functions | |||
Linear Mode
