Merge more rows into one

Thanks for reply , but that only merges the first column , i get a new sheet like :
529242
529244
529246
529247
529249
529250
529251
529256
and nothing else i need the other cells to folow this number

its like
column 1_column 2_column3_column 4
1 _______ a_______ b_______ c
1 _______ d_______ e_______ f
2_______ ab_______ bc_______ c d
2_______ de_______ ef _______ kj
2 _______ f f_______ gg_______ hg
3_______ a f_______ bn_______ cx
3_______ du_______ er_______ f s
4 _______ at_______ bp

and i need

column 1_column 2_column 3_column 4_column 5_column 6_column 7_column 8_column 9
1_______ a_______ b_______ c_______ d_______ e_______ f
2_______ ab______ bc______ cd______ de _____ ef _____ ff________gg______kj
3 ______ af_______ bn______ cx______ du______ er______ fs
4_______ a t______ bp

take " _ " as spaces
Every data in the other cells except the first is different.
hope you understand

the idea to refer to your attention to that code was to show you how to do. it had all basic logic, you would need to modify to suit your specific requirement. read his question and then solution, you should be able to alter code