Ubuntu
openoffice.org package

Pivot column in sheet1 to row in sheet2

Asked by Jason Greene

How do I make sheet2/row1 equal sheet1/column1 without having to manually do each cell?

i.e.
sheet2.a1=sheet1.a1
sheet2.b1=sheet1.a2
sheet2.c1=sheet1.a3
sheet2.d1=sheet1.a4

thanks

Jason

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
Wrwrwr
Solved:
Last query:
Last reply:
Revision history for this message
Bereg (justin-mattrazzo) said : 		#1

In the formula box once you have the first one like A1=sheet2.a1 for example. Look at the cell that you have highlighted there will be a black handle. Click and drag that down the column. That should autofill the formula all the way down.

Revision history for this message
Bereg (justin-mattrazzo) said : 		#2

Oh I think I misunderstood your question. Sorry Jason.

Revision history for this message
Jason Greene (jason-the-greenes) said : 		#3

No problem.

Revision history for this message
Best Wrwrwr (wrwrwr) said : 		#4

Select some cells in a the column in the first sheet. Copy. Select same amount of cells in a row in the second sheet. Paste Special, mark Transpose (and maybe Link, if you want them to update automatically).

Revision history for this message
Jason Greene (jason-the-greenes) said : 		#5

Thanks Wrwrwr, that solved my question.