combine cells in the same raw

[moussa854]

Hi,
I am trying to combine all cells of the same raw into one separated by space. See example below:

COL1 COL2 COL3 COL4 COL5 ...etc
1 b f 1 b f
d 8 d 8
3 a r 5 3 a r 5


I have more than 4000 rows and some rows have more than 100 columns. Any one can help, thanks in advance.

[watersev]

hi moussa854, please check attachment, press Run button, sort of that

[mike7952]

Here you go

Please Login or Register  to view this content.

[moussa854]

This is great. Thank you both for the script.