i have a huge spreadsheet which i downloaded and converted from pdf to excel.
curently i am manually highlighting (eg A1, A2, A3, A4), copying and paste special (transpose) to B1, C1, D1, E1 and then repeating this action for A5, A6, A7, A8 to B5, C5, D5, E5. How do I repeat this action with one click or a formula?
Thanks.
hello
B1 {=TRANSPOSE(A1:A4)} - array formula ctr + shift + enter
Contributors to this forum do not get paid. They give their valuable time to help you solve your problem. That's why feel free to CLICK their STARicon to say thank you -even the given idea/solution didn't really solve your queries. The time given to you deserves a small gratitude anyway.
Dare to give a pencil to a child. http://www.blackpencilproject.org/
Hi, i am embarrased to say this but i am not sure exactly where to type this formula in.
oh HI again, I think i got it. let me try it out on my giant spreadsheet.
when i am done with copying the rows and pasting them to columns, i wish to delete the original rows. In reality, i guess what i REALLY want to do is to cut a1:a4 and transpose/paste them into b1:e1. How do I do that? Currently, if i try to delete the original information in a1:a4, everything else gets deleted in b1:e1.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks