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

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

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

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