Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jaqcues
Frequent Visitor

Unpivoting & appending multiple workbooks

Hi,

 

I need to consolidate a large number of workbooks, about 30 or so, into one file

The problem is the data layout the files are coming in.

 

They are laid out like so, with date and unit of measurement ($ and QTY) in columns:

 

jaqcues_2-1666842974724.png

 

I want it unpivoted like so:

jaqcues_1-1666842939140.png

 

This would be easy if date & UOM were already merged in one cell, but since they are not, unpivoting just puts date & unit of measurement at the top of the new table.

 

Link to an example file with current extract layout and desired layout is here 

 

Any guidance would be much appreciated!

1 ACCEPTED SOLUTION
mussaenda
Super User
Super User

Hi @jaqcues 

 

For the file you provided, please check the attached file.

But the trasnformation I did is not dynamic.

This is to give you an idea.

mussaenda_0-1666844797813.png

 

If you still need help, please let me know.

 

Hope this helps.

View solution in original post

2 REPLIES 2
mussaenda
Super User
Super User

Hi @jaqcues 

 

For the file you provided, please check the attached file.

But the trasnformation I did is not dynamic.

This is to give you an idea.

mussaenda_0-1666844797813.png

 

If you still need help, please let me know.

 

Hope this helps.

Thanks for your time! This solution did work 🙂

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors