CODEWITHSUNDEEP
excelpowerquerypowerpivot
Pablohoney
Pablohoney

Reputation: 104

Excel query join tables

I have 4 tables reporting monthly sales of a product line; each table displays sales from a sdepcific channel (B2B, Ecommerce, Monobrand, Customized) and I'd like to stack these 4 tables one after the other. Each table has the same exact columns, I can't do copy and paste because I need to update the 4 tables monthly. I've tried to create a unique database and gather the information from the system throug a sequence of IF, IFS and SUMIFS but even though I get to the result, this takes forever in calculation

Is there a way to do it? I don't know, maybe with Powerquery or creating a Power Pivot?

Thank you

Upvotes: 0

Views: 64

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40264

Load the tables into Power Query and append them in the Combine section of the Home tab.

Upvotes: 1

Related Questions