Expert: Nathan Head - 7/23/2008

Question
I have a spreadsheet of data in which the dates go down the rows and the info in the month goes across the column:
Jan  1
Feb  2
Mar  3
...

I need to get the data like this:
Jan Feb Mar
1   2   3

but want it to be able to auto complete like this because the spreadsheet is updated every month and I don't want to have to re-transpose the data every time.

Answer
Brad:

Let's assume your date is in cells A1 through B3.  I am assuming your months are in A column and the numbers are in B column.

1) Select cells A1:B3.
2) Select edit->copy
3) Select the cell you want to copy to...say D1
4) Select edit->paste special
5) Select "transpose" and click OK.

The data will fill in D1:F2 just like you are showing above.

Now, this may not be the solution you are looking for...if you want something more automatic...where you paste data into Cell A1:B3 and it automatically goes to D1:F2 by itself....

There is a TRANSPOSE() function that will do this.  It is an array formula and must be entered with CTRL-SHIFT-ENTER.

1) Select D1:F3
2) Type in =TRANSPOSE(A1:B3)
3) Press CTRL-SHIFT-ENTER

Now the data is populated by formula using A1:B3 as the source.

Please let me know if you have any additional questions!