excel macro horizontal to vertical

**student21** · 2011-02-18, 05:56 AM

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

**Finetopix** · 2011-02-18 05:56 AM

**sedicla** · 2011-02-18, 06:05 AM

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

**student21** · 2011-02-18, 06:33 AM

attached an example...

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

plz help.

thx.
d

**mashi123** · 2011-02-18, 06:44 AM

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** · 2011-02-18, 06:50 AM

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** · 2011-02-18, 11:36 AM

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** · 2011-02-18, 01:16 PM

@student21

Did you try/mean the transpose function inside Excel?

**sajan_manish** · 2011-02-18, 04:03 PM

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** · 2011-02-18, 08:14 PM

@sajan_manish
sorry mate, i did not get how it works. pasting the example 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....