#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 93
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 430
Default 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!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 93
Default 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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
divide column(x) by column(y) to give column(x/y) in excel? James New Users to Excel 2 April 24th 23 11:46 AM
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look [email protected] Excel Discussion (Misc queries) 1 December 27th 06 05:47 PM
formula : =(column A)+(column B)-(column C). Why won't it work? Kristin Drover Excel Discussion (Misc queries) 3 October 18th 06 08:48 PM
Divide Column A by Column B multiply Column C Stumped Excel Worksheet Functions 3 December 28th 05 05:51 AM
what formula do i put for column m = column k minus column l in e. jenniss Excel Discussion (Misc queries) 5 January 6th 05 08:18 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"