ExcelBanter - Row vs. Column

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

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

- - Row vs. Column (https://www.excelbanter.com/excel-discussion-misc-queries/160857-row-vs-column.html)

Stephanie

Row vs. Column

Hi, there!
I am copying data from Word into Excel. I need the column of data to be a
row of data.

How can I either paste a column of data as a row of data, or convert a
column of data to a row of data?

Thanks for the help!

tim m

Row vs. Column

Copy the data and then 'Paste special' ...... 'transpose'

"Stephanie" wrote:

Hi, there!
I am copying data from Word into Excel. I need the column of data to be a
row of data.

How can I either paste a column of data as a row of data, or convert a
column of data to a row of data?

Thanks for the help!

Stephanie

Row vs. Column

Aren't you fabulous! Thanks- that worked perfectly!

"tim m" wrote:

Copy the data and then 'Paste special' ...... 'transpose'

"Stephanie" wrote:

Hi, there!
I am copying data from Word into Excel. I need the column of data to be a
row of data.

How can I either paste a column of data as a row of data, or convert a
column of data to a row of data?

Thanks for the help!

All times are GMT +1. The time now is 02:09 AM.