Hi, is there a way to convert data that looks like this table:
Style Jan Feb Mar
ABC 200 300 700
DEF 900 200 600
To become a list that looks like this:
Style Month Units
ABC Jan 200
ABC Feb 300
ABC Mar 700
DEF Jan 900
DEF Feb 200
DEF Mar 600
My data is much larger, of course, but this gives you an idea of what I am trying to accomplish. Thanks in advance!
Amy
Amy;
See my response tothis duplicate post in Access Forum.
http://www.excelforum.com/access-pro...columns-2.html
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
Duplicate post, thread closed.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks