ExcelBanter - How do I copy numbers from a column across to a row?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I copy numbers from a column across to a row? (https://www.excelbanter.com/excel-discussion-misc-queries/42752-how-do-i-copy-numbers-column-across-row.html)

cruncher

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?

Ian

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?

Tom Ogilvy

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?

cruncher

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?

All times are GMT +1. The time now is 10:10 PM.