Excel-fi Question: Data, and not like the Android
September 2, 2014 1:13 PM Subscribe
Trying to consolidate excel data with three variables (workbook date, name &widgets) and could use help. What is the most efficient way to combine this across weeks to make it summary with detail by week? What is the best tool to do this? Excel? Access? The fog of confusion follows clicking this link.
posted by Draccy to Technology (15 answers total) 2 users marked this as a favorite
I'm trying to make sense of widget numbers that have collected and stored by a different individual. They do not think the same way that I do, and I'm having trouble translating their data into a matrix that I can use for basic metrics.
I have 26 workbooks (one for each week in the first half of this year). Each is dated for the week it was created.
It contains a list of names of team members (between 20-40) and a list of widgets, but doesn't contain the date created.
The widgets currently appear as row headings, and the columns contain the names of the individuals. The date isn't really captured in the body of the spreadsheet of the workbook. To make it a little harder to consolidate, there are random spaces in between to "make it pretty" which makes it very hard to consolidate. I know that I'll have to do a lot of manual work to consolidate it, but think it will be worth it if someone can help me understand how to work with data that has three variables.
What is the most efficient way to combine this across weeks to make it summary with detail by week? Essentially I want to be able to see "Bobby" "Week Number" "Amount of Widgets" but am having trouble getting my brain to convert this data from two axis to three.
Please let me know if I'm not including enough data to answer this question. I appear to have tons of it, and no way to use it.