Merge more rows into one

[Closed]
Report
Posts
2
Registration date
Monday March 7, 2011
Status
Member
Last seen
March 8, 2011
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
i want to combine more rows into one based on the same first cell which contains the same number
ex :
529251 0 2456018 6
529251 0 2456019 7
529251 0 2456020 8
529256 0 2456025 1
529261 0 2456034 1
529261 0 2456035 2
529263 0 2456038 1
529268 0 2456117 1
529268 0 2456118 2
529268 0 2456119 3

i want them to become
529251 0 2456018 6 0 2456019 7 0 2456020 8
529256 0 2456025 1
529261 0 2456034 1 0 2456035 2
529263 0 2456038 1
529268 0 2456117 1 0 2456118 2 0 2456119 3

i need them to be in separate cells so i can print merge the whole xls , the first cell is not on a fixed interval is random sometimes i have 2 sometimes i have 3 or 6 more rows with the same number and there are different numbers of columns on some rows.
i dont know how to explain this more.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Posts
2
Registration date
Monday March 7, 2011
Status
Member
Last seen
March 8, 2011

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
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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