[Zubin Gidwani]

This one feels like one Belinda should have covered at some point in a shootout, if not Belinda you might learn something new with this and be able to call it a day early!

Received a payroll allocations data dump. listing of employees with about 70 columns of departments where they were partially allocated to…Any given employee was only allocated to about 5 of the 70 departments, but no particular pattern or easy way to pull this apart or so I thought.

I Googled the Internet (thanks Marlena for my new catch-phrase) and low and behold
There’s an unpivot command in Excel 2016 or in Power Query

1. Transformed the data grid into a table with the oh so intuitive command of selecting the data range and then going to the Insert menu and clicking the Table button, no it didn’t insert a table just converted the selected data to a table.
2. Then went to the data menu, clicked the from table button and it brought up power query
3. selected the columns to unpivot
4. clicked the unpivot button
5. and then clicked close and load

Absolute brain-bender of a task returned back in a few button clicks, nothing but net!
Have a great weekend!

Zubin

Full article and screenshots below
https://www.excel-university.com/unpivot-excel-data/

——————————
Zubin Gidwani
Dynamic Budgets
San Francisco-Bay Area CA
——————————

[Zubin Gidwani]

Ok – giving partial credit to where credit could have been given had he covered it better…

I do see that Shawn mentioned the Unpivot command in his Power Query Transformations webinar; (one slide) buried in the middle…

——————————
Zubin
——————————