Excel - Link and Transpose: Episode 1334

[@WizeChoice]

Gratitude 🙏🏾 Thank you.

[@majorkiki8340]

2 minutes of GOLD. Thank you!

[@invisiblian]

Thanks for the tip. this is among the few videos i would like twice

[@mechartisan6813]

Exactly what I was looking for, Thank you very much

[@jeenyjensen8502]

Thanks so much, this helps alot!!!!!!!

[@ramu992]

Thankyou sir !

[@brianojp]

Thank you!!!!

[@Kapspatil14]

For everyone who is not getting the result as he showed or maybe getting =value!. Listen to him carefully, you need to press Ctrl + Shift at the end. Thank you.

[@TreySmith-fu6xf]

Thank you so much! I had a large amount of linked data to transpose and the transpose wizard doesn't work or mention the Cntrl, Shift, Enter Option...Saved me a lot of time!

[@agussamudro9421]

Thanks...i solve my trouble with this!

[@LESHROCKO17]

This was pure genius! This was really helpful

[@trisha3178]

Thanks so helpful!!

[@MegaRoseBunny]

Concise and easy to understand. Thanks a lot!

[@rezabela24434]

This helped me and easy to understand, Thanks a lot

[@shamchikaify]

Thanks. This is great and it worked at the first time. I have linked data from vertical and its linked into a horizontal lookup table. But I want to apply the same thing for respective columns and rows. What is the process?

[@mrcboggie]

Thanks a lot. Should've been able to figure that out on my own

[@tahirif1138]

Is there a way to do it from horizontal to vertical ?

[@sgjokanovic7944]

You are a legend

[@littlemspd9674]

Wow, this is so awesome... It worked perfectly for me. Thank you!

[@kennethogwo]

Fantastic!

[@leavingcertmath]

Excellent video, thanks

[@asterlilies4729]

Great Sir

[@thedisguisedmaster]

great, easy way to do this task! thanks!

[@franciscotamayo6208]

Thank you so much! very useful!

[@RyanJumarPantoja]

is there a shortcut for that technique? thanks it helps me alot...

[@naimurrahman8361]

Thanks Man

[@amjadkamal2010]

wonderful, i love it thanks

[@aamir6282]

good morning deer
what we can if we have both are in horizontal for example if we have in one work book is B2:G2 and other work also same in horizontal

[@thomaserickson7213]

How do you do the reverse? (Take data that is horizontal then paste and link into a column).

[@bobbylopez9755]

I'm looking for the same thing. Have found the answer?

[@Lautaro_Guindulain]

Thank you so much!!

[@NilofurButt]

can we transpose the row into column?

[@MrXL]

Yes.

[@tamilvaanan4212]

So easy sir

[@infogabry]

amazing... better than forums

[@sekiondowarema1786]

Asante sana(Thank you)

[@sscrofa]

thanks!

[@ahmedhamdy6930]

i cant do it with merged cells

[@Kevin-rv7rm]

U rule

[@KevinYangOilers]

Sorry this doesn't work, everytime I do it it gives me a =Value!

[@subhashghosh7172]

Help me please

[@MrXL]

Tell me more

[@subhashghosh7172]

@@MrXLafter using transpose function if I try to make any changes in the resulted cells then it gives error. So is there any solution that if I make any changes in source it reflects in the result cells and vice Versa. Please reply on this 🙏

[@MrXL]

@@subhashghosh7172 Very clever question. Here is how to do it: ruclips.net/video/fkW_SLcVl0A/видео.html