Badly Constructed WookBook
I'm hoping I can get some help please.
My manager has asked me to take the attached data and pull trends and make charts, etc.
However, when I look at this data, all I see is "Why did you put it together like this?". I'm not sure what the person was thinking when they built this workbook. It seems very counterintuitive to what we want out of the data, but alas, it is what I have to work with, so...
HOW? Is there a simple way to pull this data and build the charts and trends? Am I just not seeing it?
Examples of what my Manager will want from this data:
How many Pipefitter Journeymen on Day Shift answered Question 1 "Sometimes"?
How many Welder/Burner's that have been here over 5 years answered Question 5 "Almost Always"?
Etc. Etc. Etc.
I expect slicers may come into play at some point, but first we have to pull the data correctly so it can be manipulated, no?
I've attached the files. Feel free to play! And I really appreciate any help I get from this group, you people really are amazing!
Re: Badly Constructed WookBook
Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here. I am, therefore, closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...-wookbook.html
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.
Forum Rules (updated September 2018): please read them here.
How to use the Power Query code you've been given: help here
. More about the Power suite here
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Canadian911Guy in forum Excel Formulas & Functions
Last Post: 05-31-2019, 01:03 PM
By Canadian911Guy in forum Excel Programming / VBA / Macros
Last Post: 05-18-2019, 01:02 PM
By ezkii in forum Excel Formulas & Functions
Last Post: 06-22-2018, 12:12 AM
By millerjj22 in forum Excel Formulas & Functions
Last Post: 04-29-2017, 11:37 AM
By jakopak in forum Excel Programming / VBA / Macros
Last Post: 09-24-2015, 05:56 AM
By Here2learn in forum Excel General
Last Post: 07-15-2015, 03:50 AM
By Deathwreaker in forum Excel Programming / VBA / Macros
Last Post: 05-30-2014, 05:42 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1