the last column is IV. there is a limit of 230 columns. the number of rows
can be in the 1000. You will not get all your data in 1 row.

"MarkyMark" wrote:

Is there away to create a macro to put numbers in one row with comma
between them instead having them in 3000 rows?
From
A
1 5656565656
2 5353535353
3 6262626262
4 3535353535
5 2326235623

To
A
1 "5656565656","5353535353","6262626262","3535353535 ","2326235623"