Forum Discussion
Solved
Combining data from multiple tables according to item name
I have multiple tables containing data on exports of items in each year. I want to be able to create a consolidated table which has the item name in row while the data for exports in a particular yea...
sankalpa280 Obviously, you are already working with structured tables and Power Query. Create a query that connects to all relevant tables in the current workbook. Expand the content column and group by item. Finally create a pivoted table in PQ or a regular pivot table in Excel.
A simplified example is attached.
sankalpa280 Obviously, you are already working with structured tables and Power Query. Create a query that connects to all relevant tables in the current workbook. Expand the content column and group by item. Finally create a pivoted table in PQ or a regular pivot table in Excel.
A simplified example is attached.
Thank you!