Formatting data from "Columns and Rows" to just "Rows"

  • Thread starter Thread starter Jonathan Lord
  • Start date Start date
J

Jonathan Lord

G'day,

I am currently pulling my hair out attempting to summarise
a set of data which is formatted as rows and columns into
a format whereby it is just presented as columns.

The row headings on the left are a list of different
Products and across the top the column headings are
Months/Years with the corresponding data being sales
volumes by product by month.

What i need to do is format this data so that in rows
going down the page I have the forecast volumes by Product
by Month....for example: Red Wine September 2003 20,000
then the next row would be Red Wine October 2003 15,000
and so on and so forth for each individual product there
would be an instance for each month.

I am sure that I am not the first person who needs to
perform such a task in Excel and hope that somebody out
there can help with a solution of some sort???

Regards,

Jonathan
 
Hi,

You may want to TRANSPOSE the information.

Copy the data then goto a blank are, maybe a new sheet,
then Edit > Paste Special and select Transpose.

This makes the columns:rows and the rows:columns.


I am not sure about the question but you can send me a
sample of the sheet, about 5 rows - dummy data is okay.

(e-mail address removed)

See some stuff at: http://au.geocities.com/excelmarksway
 
Back
Top