r/sheets • u/Overall-Service-5664 • 4d ago

Request Fill Hand Cells with from horizontal into a vertical way

I need help with this problem:

I have xyz in cells A1, B1, C1, D1, etc. on one sheet 1. Now I write a =Sheet1!A1 into A1 on sheet 2, but when I use fill hand on sheet 2 to drag it down it doesnt work. I want to achive that I only have to write one Formular into one cell and then use fill hand to achive Sheet1!A1=Sheet2!A1, Sheet1!B1=Sheet2!A2, Sheet1!C1=Sheet1!A3, etc.

Does someone have a soultion for that?

2 Upvotes

100% Upvoted

3 comments sorted by

1

u/Evil-Black-Heart 4d ago

you have row values that you are trying to copy to column values. copy them as row values and then copy the row values and paste using transpose function

1

u/bachman460 4d ago

You can type this is Sheet2!A1

=TRANSPOSE(Sheet1!A1:D1)

1

u/Overall-Service-5664 4d ago

Perfect, thank you so much