Ian,

You can try two things:

(1) You can copy the data in a row and transpose it into a column and visa
versa. Assuming you want to copy a column to a row, select the column of
data. Go to the standard toolbar and select Edit - Copy. Go to the first
cell of the row where you want to paste the data. Go to the standard toolbar
and select Edit - Paste Special - Transpose. Then hit the OK button. The
Transpose option is at the bottom right side of the Paste Special dialog box.

(2) You can use the TRANSPOSE worksheet function (might want to look in
Excel's on-line help for this) in a formula.

----
Regards,
John Mansfield
http://www.pdbook.com

"Ian Johnson" wrote:


I have a worksheet that has a list of cities as row headers, and dates as
column headers with numeric values for data. It shows the # of new
construction permits issued in each metro area per month.

I need to select all the values for a city which are in a row, and paste
them into a column on the worksheet which will do the calculations I need. I
can't figure out how to change the source worksheet so that the cities are
columns and the dates are rows so I can do a simply copy/paste.

Is there a formula or something I can give to the first cell of the
destination column that will let me identify the first cell of the source row
and then automatically fill the rest of the destination column with the
values in the source row?