# Merge more rows into one

Closed
pinguyn Posts 2 Registration date Monday March 7, 2011 Status Member Last seen March 8, 2011 - Mar 7, 2011 at 02:17 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 8, 2011 at 06:20 AM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 8, 2011 at 12:48 AM
pinguyn Posts 2 Registration date Monday March 7, 2011 Status Member Last seen March 8, 2011
Mar 8, 2011 at 04:34 AM
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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 8, 2011 at 06:20 AM
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