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?