chiku
2010-05-29, 05:02 AM
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
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