excel macro horizontal to vertical

[student21]

hi guys,

does anyone have an Excel macro that transforms the neighbor list from horizontal (one cell per one row, with its neighbors) into vertical list (two columns: source-target)

appreciated.
d

[sedicla]

Do you have a sample, because it´s not very clear.

[student21]

attached an example...

http://rapidshare.com/files/448492028/H2V_Example.xls

plz help.

thx.
d

[mashi123]

My advice to u is to try to make it by your self .macros will help u alot as optimizer but u should have ur own macros

[student21]

if i had time to follow your advice, i would not post this question here, mate...

if anyone have the Excel macro ready, please share. i do not know what to do with the code even...

thx in advance.
d

[rfworld]

If you want a ready solution you can use Cell to Cell Handover Performance Report (Source cell to all target cells) which i believe should be available for any vendor.I can provide you the E/// BO template if you want.

[DCA]

@student21

Did you try/mean the transpose function inside Excel?

[sajan_manish]

to convert vertical to Horizontal , you need to make seprate .xls file , then go to vertical sheet press alt + F8 , it ask to to proivide input sheet then run it...

for hor to vertical just paste hori cell on horizontal sheet and rum macro ( alt + F8 )

please add thanks and reputation if you like , sheet without password
enjoy
manish

[student21]

@sajan_manish
sorry mate, i did not get how it works. pasting the example (http://rapidshare.com/files/448492028/H2V_Example.xls) it did not put all the horizontal list into vertical. only the first left from each list.

@DCA
i would use it if there are 2, 3 cells... i have over 1000 cells with a total of over 69000 neighbour relations....

please help....