How To Combine Multiple Columns Into One Single Column In Google Sheets?

Whether you’re organizing survey data, merging name fields, or stacking column values into a single list — Google Sheets offers multiple ways to combine multiple columns into one.

---

✅ Scenario:

Suppose you have this data:

A	B	C
Tom	Alice	John
Sam	Ravi	Riya

You want to create a single vertical list like:

nginxCopyEditTom  
Sam  
Alice  
Ravi  
John  
Riya

---

🔹 Method 1: Use the FLATTEN Function (Quick & Easy)

Formula:

excelCopyEdit=FLATTEN(A1:C2)

Result:

It combines all the values from the range A1:C2 into a single column.

📝 Note: FLATTEN() reads the data row-wise, moving left to right, top to bottom.

---

🔹 Method 2: Using ARRAYFORMULA with SPLIT and JOIN

If your data is dynamic or you want to control delimiters, use this formula:

excelCopyEdit=TRANSPOSE(SPLIT(JOIN(",", A1:C2), ","))

✅ What It Does:

• JOIN(",", A1:C2) → Converts your 2D data into one comma-separated string.
• SPLIT(..., ",") → Splits it back into individual elements.
• TRANSPOSE(...) → Converts the horizontal array into a vertical column.

---

🔹 Method 3: Stack Columns Vertically Using FILTER

If you want to stack entire columns (e.g., A, B, C) but remove blank cells, use:

excelCopyEdit=FILTER(A:A, A:A <> "")

Repeat for B and C, or stack together like:

excelCopyEdit={FILTER(A:A, A:A <> ""); FILTER(B:B, B:B <> ""); FILTER(C:C, C:C <> "")}

This ensures that blank cells are skipped and data appears vertically.

---

🚀 Ready to Master Google Sheets from Basics to Brilliance?

🎓 All of these tricks and tons more are explained with step-by-step videos in my bestselling Google Sheets course:

🔗 🔓 Unlock the Power of Google Sheets – Enroll Now!

💥 Limited-Time Offer: ₹1,299 → ₹449 only!

📘 Course Highlights:

• 29 expertly crafted videos
• 3 hours and 46 minutes of quality content
• Covers basic to advanced topics (formulas, pivot tables, automation, scripts)
• Ideal for students, professionals, freelancers, business users

💡 Learn how to organize, automate, and analyze your data like a pro.

---