Ravindra BagaleCourses & study guides मराठी Track your progress

10. Power Query in Excel

10.4 Append: FreshGo + MarketRush

By Last updated:

Append queries in Power Query with example — in 30 seconds

What: Append stacks the rows of two queries with the same columns, one under the other.

Why: FreshGo and MarketRush send separate files. The report needs one Orders table.

Tiny example: 2 FreshGo rows + 2 MarketRush rows = 4 rows worth ₹676.

First look at the data (before → after):

Append queries in Power Query with example: before and after tables, fictional FreshGo Maharashtra data

Expected result — Query: All Orders

Order ID City Amount
BLK-1001 Pune 64
BLK-1002 Nashik 270
AMN-1003 Pune 110
AMN-1005 Kolhapur 232

About this data: Teaching sample for a fictional shop “CityBasket Retail”. Figures and names (e.g. Aamir Khan) are made up for this lesson on append FreshGo MarketRush.

Before table and formula as text

Before — Query: FreshGo

Order ID City Amount
BLK-1001 Pune 64
BLK-1002 Nashik 270

About this data: Demo table only — not real customer or company data. Built to practise append FreshGo MarketRush.

Before — Query: MarketRush

Order ID City Amount
AMN-1003 Pune 110
AMN-1005 Kolhapur 232

About this data: Made-up rows so you can copy the pattern for append FreshGo MarketRush. Currencies may use ₹, £, € or $.

Formula / click path

Home › Append Queries › Append Queries as New
First table: FreshGo · Second table: MarketRush

Do it step by step:

  1. Load both files into Power Query (Data › Get Data).
  2. Check the column names match exactly in both queries.
  3. Click Home › Append Queries › Append Queries as New.
  4. Pick FreshGo as the first table and MarketRush as the second. Click OK.
  5. Rename the new query All Orders and click Close & Load.

Append = stack tables with the same columns one below the other (like VSTACK, but refreshable and good for big data).

Steps in Excel

  1. Load both sources as queries: Blinkit_Orders and AmazonNow_Orders (Close & Load To… › Only Create Connection for each).
  2. Make column names identical (e.g. rename Order Amount in MarketRush to Amount, Locality to Area).
  3. Add a Platform column in each (Add Column › Custom Column = "FreshGo" / = "MarketRush") if not already present.
  4. Home › Combine › Append Queries › Append Queries as New › Two tables (or Three or more) › select both › OK.
  5. Rename the new query All_Orders › check row count = FreshGo rows + MarketRush rows › Close & Load.

Worked example. FreshGo November file: 3,120 rows; MarketRush: 1,680 rows (fictional). All_Orders: 4,800 rows. Columns that exist in only one file (e.g. Coupon Code in FreshGo) appear with null for the other platform's rows.

Ravindra Bagale's Tip

Append matches columns by name, not by position – "Amount" and "Order Amount" become separate columns and half the values come out null. Many students think the data has disappeared. Before appending, make the column names in both queries exactly the same (spelling, spaces, case).

Practice tasks (10+)

Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.

1. Rebuild the smallest example of append FreshGo MarketRush on a blank sheet for Orbit Logistics.

Hint: Use only the steps on this page. Keep numbers numeric.

2. Change one input for Meera Joshi and confirm the result updates.

Hint: If the result is stuck, check absolute vs relative references.

3. Repeat the same steps with a £ or € value for Carlos Rivera.

Hint: Formatting must not break SUM.

4. Write the result meaning in one plain sentence next to the cell.

Hint: Imagine explaining it to a new joiners.

5. Add a second row and fill the method down.

Hint: Double-click the fill handle if the pattern is consistent.

6. Break the example on purpose, then fix it using this lesson.

Hint: Common break: text instead of a number.

7. Apply append FreshGo MarketRush to a 5-row made-up Orbit Logistics table.

Hint: Keep column headers clear.

8. Check your answer with a simple total or COUNT.

Hint: A wrong total usually means a format or key mismatch.

9. Swap ₹ and $ on one column and re-check totals.

Hint: Stored values stay the same; only the display changes.

10. List two mistakes beginners make with append FreshGo MarketRush.

Hint: Look back at the tip box on this page.

11. Teach the steps out loud in under one minute.

Hint: Why → What → How.

12. Save the sheet as OrbitLogist_practice.xlsx.

Hint: Use a clear file name for class.

Loading practice tasks...

  1. Total orders (Easy): Add up Orders in D2:D11.
  2. Total GMV (Easy): Add up GMV (£) in E2:E11.
  3. Blinkit rows (Easy): How many rows have Platform "Blinkit"?
  4. Max GMV (Easy): Largest GMV (£) in E2:E11.
  5. Grocery rows (Easy): How many rows have Category "Grocery"?
  6. Blinkit GMV (Medium): Total of GMV (£) where Platform is "Blinkit".
  7. Amazon Now orders (Medium): Total of Orders where Platform is "Amazon Now".
  8. Orders over 500 (Medium): How many rows have Orders > 500?
  9. GMV of London Amazon Now (Medium): GMV (£) for the London Amazon Now snacks row via XLOOKUP on City "London".
  10. Share Blinkit GMV (Hard): Blinkit GMV / all GMV, 3 decimals.
  11. Avg AOV (Hard): Average of AOV (£) in F2:F11, rounded to 1 decimal.
  12. Above avg orders? (Hard): "High" if D2 > average orders else "OK".

See all practice tasks in the Task Hub →

Quick revision cards

Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.

Revision card 1: What is Append FreshGo MarketRush?
Card 1: What is Append FreshGo MarketRush? · Download PNG
Revision card 2: Tiny example — Append FreshGo MarketRush
Card 2: Tiny example — Append FreshGo MarketRush · Download PNG
Revision card 3: Checklist — Append FreshGo MarketRush
Card 3: Checklist — Append FreshGo MarketRush · Download PNG