Smart Transpose

[justdream]

Guys, if you have huge number of sites and beside each of them the neighbors as shown in the attached excel, how could I transpose them automatically to get the output as in pic (I know how to do that manually for each site, but this is so stupid and will waste my time)

so do you know automatic way :hug:
Please advice

[davidbrayan]

one simple thing,
record a macro, do it once and let it do it for all others

BR
db

[justdream]

Thanks David,
I didn't use Macro before could you guide me,

Thanks and reputation in advance :D

[davidbrayan]

got developer then click record macro then give it a shortcut key then start recording.
do it for one cell, then stop recording, and play it again using that shortcut key u provided,
i may give u a formula tomorrow which will work better or some macro.
till then try by ur self

BR
db

[justdream]

Thanks again, I will try it but if you have seen my attached excel,
the number of neighbor for each site is not the same........so in each time I will do transpose for different number of rows

[venom]

Thanks again, I will try it but if you have seen my attached excel,
the number of neighbor for each site is not the same........so in each time I will do transpose for different number of rows


See and find my macros in Gtool post ;) !

[justdream]

See and find my macros in Gtool post ;) !

Thanks man, you and hassen are my experts,
I tried to give you reputation but I failed as I have already gave you a lot....I will try later :D

Thanks again

[venom]

Thanks man, you and hassen are my experts,
I tried to give you reputation but I failed as I have already gave you a lot....I will try later :D

Thanks again

If u want to know what is going behind the code then u can bypass the password of VBA.

tool for Bypassing password of VBA is already shared in finetopix ;)

Learn it and it will help you to generate something more beneficial for urself

Note: When converting Vertical to Horizontal , use Numerical Data in SRC ID, you can use STRING in TGT ID !!

If your SRC ID is not numerical then the macro will not run !!

[justdream]

@ venom


Thanks a lot, I've used your macro during last year (it was perfect)..
but now I've very big excel file...I observed that your macro can't work well in case of very big data

so, is there any other solutions?

[alg_optim]

Genex Nastar can do that .


B.R
Alg_optim

[justdream]

If u want to know what is going behind the code then u can bypass the password of VBA.

tool for Bypassing password of VBA is already shared in finetopix ;)

Learn it and it will help you to generate something more beneficial for urself

Note: When converting Vertical to Horizontal , use Numerical Data in SRC ID, you can use STRING in TGT ID !!

If your SRC ID is not numerical then the macro will not run !!

Please my friend, where is this tool that Bypassing password of VBA?
I need it urgently (I've searched in the forum but didn't found) may be my keywords are not exact
please help :hug:

[mayank_shah]

Hi Please find the attached...

[rasar00]

thank you for this information

[auto_art]

use this maro..it wil do ur task....
it does contain both row to col & col to row.