PC Review


Reply
Thread Tools Rate Thread

Converting Data from Rows to Columns

 
 
A
Guest
Posts: n/a
 
      30th May 2006
I have a large table of data that contains many rows of information,
categorised by row. I would like to be able to convert this into a table
with the same date categorised into columns.

E.g. Row 4 contans the data '531,331,342 etc'
I would like this data to be presented down column D in the same order.

The reason for this is that It would be far easier for me to copy formulas
down the columns rather than along the rows.

How can I do this?

Thanks in advance


 
Reply With Quote
 
 
 
 
aaron.kempf@gmail.com
Guest
Posts: n/a
 
      30th May 2006
keep your data in a database; and it is easy to turn it into rows or
columns.

excel is 1-dimensional. run away while you still can.

 
Reply With Quote
 
shelfish
Guest
Posts: n/a
 
      30th May 2006
A better response would be, select all of your data and copy. I
recommend you select a new sheet (but you don't have to) and select
"Paste Special..."

In the menu select "Transpose" and see what happens. It should do what
you're asking.

Cheers!

 
Reply With Quote
 
A
Guest
Posts: n/a
 
      31st May 2006
Fantastic.

Thanks very much, I appreciate your help.


"shelfish" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>A better response would be, select all of your data and copy. I
> recommend you select a new sheet (but you don't have to) and select
> "Paste Special..."
>
> In the menu select "Transpose" and see what happens. It should do what
> you're asking.
>
> Cheers!
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting from rows to columns =?Utf-8?B?VHJpcHAgSw==?= Microsoft Excel Misc 3 9th May 2007 12:00 PM
Converting columns to rows alfred.cloutier@gmail.com Microsoft Excel Worksheet Functions 4 15th Feb 2007 11:13 PM
Need help with Converting Rows of data into 2 columns Steve Microsoft Excel Worksheet Functions 3 11th Aug 2005 04:41 AM
Converting Rows of Data to Columns Greg Flowers Microsoft Excel Discussion 3 8th Mar 2005 08:43 PM
Converting rows of data into columns Ian McD Wood Microsoft Excel Misc 1 17th Aug 2004 07:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:33 AM.