Practice and Answer Key: Append, Unpivot and Group By

Suppose Ravina gets two small files every month: Blinkit orders and Amazon Now orders, typed with months as columns. She wants orders per city for both platforms together. All data is fictional.

Blinkit file

Amazon Now file

Exercise (one under the other):

1. Load both files with Data › Get Data, choose Transform Data.
2. In each query, select City and click Transform › Unpivot Columns › Unpivot Other Columns.
3. Rename Attribute to Month and Value to Orders.
4. Add a custom column Platform with the platform name in each query.
5. Click Home › Append Queries › Append Queries as New.
6. In the appended query, click Transform › Group By: group by City, Sum of Orders.
7. Click Close & Load.

Expected result (check your numbers):

The appended long table has 8 rows. Total orders = 670.

Each query: Unpivot Other Columns (keep City) → rename Attribute = Month, Value = Orders
Add Column › Custom Column: Platform = "Blinkit"   (or "Amazon Now")
Home › Append Queries as New: Blinkit + Amazon Now
Transform › Group By: City · New column Orders = Sum of Orders

Common mistakes:

Ravindra Bagale's rule: shape each file the same way first, then append, then summarise.