Please help me with this data
 

Dear all;
I want to put the data in cells A,B,C.D in one cell respectively see
may example
A B C D
30 6 7 8
32 2 3 4
22 3 4 5
45 4 5 6
67 5 6 7
42 6 7 8


Results like this
30
32
22
45
67
42
6
2
3
4
5
6
7
3
4
5
6
7
8
4
5
6
7
8

Thank you

Please help me with this data
 

Enter this formula in A7 and copy down as needed:

=OFFSET($B$1,MOD(ROWS($A$1:A1)-1,6),INT((ROWS($A$1:A1)-1)/6))

The 6 in the formula represents the number of rows in each column of data.
Change as needed.

Biff

"Ahmad" wrote in message
oups.com...
Dear all;
I want to put the data in cells A,B,C.D in one cell respectively see
may example
A B C D
30 6 7 8
32 2 3 4
22 3 4 5
45 4 5 6
67 5 6 7
42 6 7 8


Results like this
30
32
22
45
67
42
6
2
3
4
5
6
7
3
4
5
6
7
8
4
5
6
7
8

Thank you

Please help me with this data
 

The formula is work ok, thank you for help
Biff wrote:
Enter this formula in A7 and copy down as needed:

=OFFSET($B$1,MOD(ROWS($A$1:A1)-1,6),INT((ROWS($A$1:A1)-1)/6))

The 6 in the formula represents the number of rows in each column of data.
Change as needed.

Biff

"Ahmad" wrote in message
oups.com...
Dear all;
I want to put the data in cells A,B,C.D in one cell respectively see
may example
A B C D
30 6 7 8
32 2 3 4
22 3 4 5
45 4 5 6
67 5 6 7
42 6 7 8


Results like this
30
32
22
45
67
42
6
2
3
4
5
6
7
3
4
5
6
7
8
4
5
6
7
8

Thank you

Please help me with this data
 

You're welcome. Thanks for the feedback!

Biff

"Ahmad" wrote in message
oups.com...
The formula is work ok, thank you for help
Biff wrote:
Enter this formula in A7 and copy down as needed:

=OFFSET($B$1,MOD(ROWS($A$1:A1)-1,6),INT((ROWS($A$1:A1)-1)/6))

The 6 in the formula represents the number of rows in each column of
data.
Change as needed.

Biff

"Ahmad" wrote in message
oups.com...
Dear all;
I want to put the data in cells A,B,C.D in one cell respectively see
may example
A B C D
30 6 7 8
32 2 3 4
22 3 4 5
45 4 5 6
67 5 6 7
42 6 7 8


Results like this
30
32
22
45
67
42
6
2
3
4
5
6
7
3
4
5
6
7
8
4
5
6
7
8

Thank you