Repeat copy and paste special (transpose)

**Mengtzee** · 01-13-2012, 04:51 PM

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.

**vlady** · 01-13-2012, 10:25 PM

hello

B1 {=TRANSPOSE(A1:A4)} - array formula ctr + shift + enter

**Mengtzee** · 01-16-2012, 09:47 AM

Hi, i am embarrased to say this but i am not sure exactly where to type this formula in.

**Mengtzee** · 01-16-2012, 10:02 AM

oh HI again, I think i got it. let me try it out on my giant spreadsheet.

**Mengtzee** · 01-16-2012, 11:38 AM

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.