unpivoting

Dear All, I am not sure how to unpivot data in Power Query to get the desired outcome, please see the picutre. Currently the data layout is in a way where all the months are in column for Actual, Budget, Forecast and WTE for each month. My aim is to have data in a way where I can easily use...

Hello all, See table for example data set. I have transformed 2 files, one "Actual", one "Budget", and they are appended. How do I unpivot the "Source.Name" column in a way where I have two columns, "Actual" and "Budget", their corresponding value for GL Code, GL Name, and Cost Center? I will...

Here is what I have... A supervisor updates 1 timesheet for every day of the week (7 total) Each time sheet is saved under the same sheet stacked vertically (see sheet picture) At the end of the week the data from these 7 individual timesheets must be summarized as a list of records on another...

Hi all, I need help on a data transformation assignment in Power Query. The goal is to unpivot and unstack data from two tabluar data sets and transform them into a list. Data Source = 2 .xlsx Files in Folder (please see data example below) Data Type = Tablular format with yearly dates on...

Hi all, I'm using Excel 2011 on a Mac, I have the Developer tab available. I have a workbook that looks like this: <colgroup><col width="50" span="17" style="width: 50pt;"></colgroup><tbody> Family Genus Species Blood / Heart Teeth / Mouth Guts / Stomach Sexual health Neurological General...

Hi guys, I've tried a range of functions and formulas to try and effectively unpivot this list of university programs. Anyone got any ideas how to do it dynamically? See file here: http://bit.ly/2brupU4 Cheers Shane