[vcff]

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

[RagDyeR]

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

[Max]

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

[vcff]

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

[Max]

No prob, welcome.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"vcff" wrote in message
...
Thanks Max

That was what I needed

[vcff]

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

[RagDyeR]

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