Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Julian
 
Posts: n/a
Default Stack multiple columns into one column... is there an easy way?

I have data I need to analyze with a Pivot Table, but I can't because there
are multiple columns. I have time series data, where the first column has the
item name, and the rest of the columns have weekly sales, one column per
week. However, I can't analyze it because I need the weekly data to be in a
single column (this is the only way I know how to analyze it and graph it).

Does anybody know if there is an easy way to stack this weekly information
into a single column, where the first column has the item name, second column
the date, and the third column the sales data? This will really help. Right
now it takes me 3 hours to re-arrange the data manually because there are
like 200 columns, each with 150 rows!

Thanks in advance.
  #2   Report Post  
flydecoder
 
Posts: n/a
Default


I am having a hard time trying to picture what you are looking for.

Can you give a small example, say 5 rows by 5 columns of fake data so I
can see the before and after desired effect?


--
flydecoder
------------------------------------------------------------------------
flydecoder's Profile: http://www.excelforum.com/member.php...o&userid=27288
View this thread: http://www.excelforum.com/showthread...hreadid=468076

  #3   Report Post  
Julian
 
Posts: n/a
Default

Ok, for example:

STORE 8/1 8/7 8/14
Ralphs 500 250 300
Vons 150 740 200

And I need the data to be like this:
STORE SALES DATE
Ralphs 500 8/1
Vons 150 8/1
Ralphs 250 8/7
Vons 740 8/7
Ralphs 300 8/14
Vons 200 8/14

I hope this illustrates what I need.
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
How do I incorporate 2 columns into 1 column mayhewvb Excel Discussion (Misc queries) 3 June 16th 05 04:10 AM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 11:36 PM
splitting 1 column of data into multiple columns CiceroCF Setting up and Configuration of Excel 1 March 25th 05 02:50 AM
spliting a column of data into multiple columns CiceroCF Excel Discussion (Misc queries) 7 March 25th 05 01:40 AM
How can I sort an entire spreadsheet from a list prod sorter Excel Worksheet Functions 4 November 17th 04 04:43 AM


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

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

About Us

"It's about Microsoft Excel"