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, but now I have a problem when using Paste Transpose feature but it doesn't work as I expected, for example I have a Column Filter using 14 rows and for example 2 rows which in essence I want data this is neatly arranged the way Paste Transpose works, to be able to find out about this problem clearly you can check the video that I made as well as the example excel file that I attached. Please help, thank you.
File Excel : https://cdn.discordapp.com/attachments/1021636706396536985/1092663230029111296/Belajar.xlsx
Video : https://cdn.discordapp.com/attachments/1021636706396536985/1092680395847372840/bandicam_2023-04-04_11-06-45-417.mp4
3 Replies
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.
