| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I copy numbers from a column across to a row?
I have a spreadsheet with numbers by date down a column and I need to copy
the numbers to dates spread across a row. How do I bring them over? |
|
#2
|
|||
|
|||
|
If you mean you want to copy eg A1:A10 to B1:K1 then use Paste Special and
select Transpose. -- Ian -- "cruncher" wrote in message ... I have a spreadsheet with numbers by date down a column and I need to copy the numbers to dates spread across a row. How do I bring them over? |
|
#3
|
|||
|
|||
|
copy the data and use Edit=PasteSpecial and select Transpose.
-- Regards, Tom Ogilvy "cruncher" wrote in message ... I have a spreadsheet with numbers by date down a column and I need to copy the numbers to dates spread across a row. How do I bring them over? |
|
#4
|
|||
|
|||
|
Thank you
"Ian" wrote: If you mean you want to copy eg A1:A10 to B1:K1 then use Paste Special and select Transpose. -- Ian -- "cruncher" wrote in message ... I have a spreadsheet with numbers by date down a column and I need to copy the numbers to dates spread across a row. How do I bring them over? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average of numbers in column between to other numbers | Excel Discussion (Misc queries) | |||
| How do I copy every 8th cell in a column | Excel Discussion (Misc queries) | |||
| add only positive numbers and avg in a column | Excel Worksheet Functions | |||
| Add selected numbers in a column that are a different color | Excel Discussion (Misc queries) | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Linear Mode
