Clotting vertical data into Horizontal

[makinmomb]

Say I have this on A1 AND B1

BALL 1
PEN 2
PENCIL 1
RUBBER 3
CUP 4
PLATE 1
SAUCER 1

[makinmomb]

Formula on b1 to drag down to give results

BALL 1 , PEN 2 , PENCIL 1 , RUBBER 3 , CUP 4 ,
PLATE 1 , SAUCER 1

[makinmomb]

Collecting 5 rows , to work on long list say 1000 rows and above

[José Augusto]

Hi
To transpose the values use

Please Login or Register  to view this content.

and copy this to right and down.

See the file Transpose.xlsx
Best Regards

[makinmomb]

No , Need expected results on c1 as

BALL 1 , PEN 2 , PENCIL 1 , RUBBER 3 , CUP 4 ,

[José Augusto]

Hi
Try this in C1 and copy right

Please Login or Register  to view this content.

Is that?
see the file Transpose (2).xlsx
Regards

[Czeslaw]

Please Login or Register  to view this content.

[samba_ravi]

If your problem not resolved attach sample file with desired result