Forum Discussion
Paste Transpose
Hi Guys! I am new here, sorry about my broken English. I'm currently in need of help solving a problem I'm experiencing in Microsoft Excel. I have several variables to enter into the Column Filter, b...
You'd have to do it in two steps:
First copy A14:A27, and paste/transpose it to A2.
Then copy A28:A41, and paste/transpose it to A3.
- Hi Hans, Thank you for replying me
i need answer with simple way so how to do it directly with one step only?
imagine have 100 variables it will takes a lot of time to copy 1 by 1 :')Since you specified Excel for the Web, you can probably use one of the new dynamic array functions. I hope that someone else will help you with that.
