Macro to convert vertical neighbor list to horizontal neighbor list.

[bdplanner]

Dear macro experts,

Is there any macro available to convert vertical neighbor list to horizontal neighbor list?

We have
Serving Cell	Neighbor Cell
BOBTG1WA	BOBTG1WB
BOBTG1WA	BOBTG1WC
BOBTG1WA	BOBTG1WD
BOBTG1WA	BOBNN1A
BOBTG1WA	BOBNN1B
BOBTG1WB	BOBTG1WA
BOBTG1WB	BOBTG1WC
BOBTG1WB	BOBTG1WE
BOBTG1WB	BOBGB1C
BOBTG1WB	BOBNN1B
BOBTG1WC	BOBTG1WA
BOBTG1WC	BOBTG1WB
BOBTG1WC	BOBTG1WF
BOBTG1WC	BOBGM1A
BOBTG1WC	BOBGM1B
We need
BOBTG1WA	BOBTG1WB	BOBTG1WC	BOBTG1WD	BOBNN1A	BOBNN1B
BOBTG1WB	BOBTG1WA	BOBTG1WC	BOBTG1WE	BOBGB1C	BOBNN1B
BOBTG1WC	BOBTG1WA	BOBTG1WB	BOBTG1WF	BOBGM1A	BOBGM1B

[bdplanner]

http://www.finetopix.com/showthread....+to+horizontal

already here .. thanks to this great forum

[haider79]

Dear bdplanner,

would you please support me to have macro to transpose neighbors from horizontal to vertical.

Many thanks.

[lihanbok]

Hi haider79,
You can get macro to transpose neighbors from horizontal to vertical:
1.You download R to C Neighbors formatting.rar file post #7: http://www.finetopix.com/showthread....-neighbor-list
2.Run the excel file
3.Press Ctr + F8 to run Macro
4.Click Edit.
Now you can get the macro to transpose neighbors from horizontal to vertical.
Brs,
Lihanbok.

[trongcongbk]

Dear bdplanner,

would you please support me to have macro to transpose neighbors from horizontal to vertical.

Many thanks.

As you required!!!