Mileage chart

[kurtsz]

All I want to do is create a simple mileage chart similar to what is found in road atlases. My data is zip codes and only want to type them once.

How do I transfer the data in a column to a row? I tried =$A2 and then dragging but my data in the following cells were either the same or 00000.

[sweep]

Hi,

Select the data (no the whole column, just the cells with data in)

Edit > Copy

Select the cell where you want the row of data to start

Edit > Paste Special > Transpose > OK

[kurtsz]

Well, that was almost too easy. Thanks