Table help!!!

Contributor

Hey guys

 

I need to put the following example into a table that allows me to filter via term and metric. There are 12 terms each containing 1-5 weeks. This data, however, is on seperate sheets in seperate workbooks.

 

What's the best way I can set this up? 

 

Screen Shot 2022-06-03 at 7.07.03 pm.png

1 Reply

@cheeseontoast101 You're not very specific, but it seems that PowerQuery, indeed, is the tool you need. Connect to all files in a folder and get everything in one table. Then flatten it (i.e. unpivot) and do further analysis from there.

Exactly how is difficult to tell without more information.