Can you drag/copy in a different direction

[ds_robb]

I currently have a table on sheet 1 which has names of people going A1:A15 and then dates going across B1 to Z15. I want to now transpose that so the data is names of the people going across the top A1 to O1 and the dates go from A2 to A26. I know you can do a cut & paste to transpose, but I need this table to be a lookup from sheet one, so for example I would put =Sheet1!A1, obviously is I copy that across, it's getting the wrong orientation of the data I now want. The reason I can't transpose it using cut and paste is that Sheet1 values will be updated and I need them to reflect on Sheet2 in the appropriate cell (but now horizontal rather than vertical)

Thanks in Advance

 

[Yongle]

In Excel 365 this works
Formula in cell A1 in Sheet2
=TRANSPOSE(Sheet1!A1:Z15)
and format column A as dates

If that does not work in your version of Excel ...
- select A1:O26 in Sheet2
- use above formula
- and confirm with {CTRL}{SHIFT}{ENTER}

see

MS Excel: How to use the TRANSPOSE Function (WS)

This Excel tutorial explains how to use the Excel TRANSPOSE function with syntax and examples. The Microsoft Excel TRANSPOSE function returns a transposed range of cells. For example, a horizontal range of cells is returned if a vertical range is entered as a parameter.

www.techonthenet.com

 

[ds_robb]

In Excel 365 this works
Formula in cell A1 in Sheet2
=TRANSPOSE(Sheet1!A1:Z15)
and format column A as dates

If that does not work in your version of Excel ...
- select A1:O26 in Sheet2
- use above formula
- and confirm with {CTRL}{SHIFT}{ENTER}

see

MS Excel: How to use the TRANSPOSE Function (WS)

This Excel tutorial explains how to use the Excel TRANSPOSE function with syntax and examples. The Microsoft Excel TRANSPOSE function returns a transposed range of cells. For example, a horizontal range of cells is returned if a vertical range is entered as a parameter.

www.techonthenet.com

Thank you so very much, this is what I've been looking for and has saved me an absolute age.