Help for neighbour require

[chiku]

Hi

I need some help related to excell converting neighbour cell from colum to row as shown below.i have attached excell sheet with it.please someone can help me on that

Column1 Column2
Serving cell identity Neighbour Cell Identity
35021 35022
35021 35023
35021 35032
35021 36541
35022 35021
35022 35023
35022 36542
35023 33333
35023 23987


i want output as below

Column1 Column2
Serving cell identity Neighbour Cell Identity
35021 35022,35023,35032,36541
35022 35021,35023,36542
35023 33333,23987

[gprastomo]

Hi,

find the attached


Hi

I need some help related to excell converting neighbour cell from colum to row as shown below.i have attached excell sheet with it.please someone can help me on that

Column1 Column2
Serving cell identity Neighbour Cell Identity
35021 35022
35021 35023
35021 35032
35021 36541
35022 35021
35022 35023
35022 36542
35023 33333
35023 23987


i want output as below

Column1 Column2
Serving cell identity Neighbour Cell Identity
35021 35022,35023,35032,36541
35022 35021,35023,36542
35023 33333,23987

[chiku]

you r genius .

this will make my day.

i want macro for same so that in future i can work on it

[mojiiiiii]

i need this macro also

[dk2000]

I need also.

Can someone share the tool auto make neighbor!!