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.
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
Sarcasm - because beating the **** out of someone is illegal.
Well, that was almost too easy. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks