how to make Excel/Access data have more than one quantity in a table?

Posted by Xrave on Super User See other posts from Super User or by Xrave
Published on 2011-01-31T21:54:10Z Indexed on 2011/01/31 23:28 UTC
Read the original article Hit count: 151

Filed under:

Sorry for the confusing question, I'm not sure how to word it right: here's a mock sample of my data

Name: Cheeseburger
Date: 1/20/2011
Stock: 30
Price: 200
Name: Hamburger
Date: 1/20/2011
Stock: 12
Price: 180
Name: Cheeseburger
Date: 1/21/2011
Stock: 31
Price: 210
...

I will have to make a table in excel or access capable of looking up the stock and price trends of a particular brand through time.

Trouble is, I have two independent variables (Stock, Price) and two known dependent variables (Name, Date).

So, I cannot use a simple table where the x axis is the name, y axis is the time, and the cells represent a quantity - each cell have to represent two quantities (Stock, Price)

Does anyone know how to do that? Thanks.

© Super User or respective owner

Related posts about excel