Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets: Merge Data into One Column

onecolumn google sheets spreadsheet merge columns of data
Google Sheets: Merge Data into One Column

onecolumn google sheets spreadsheet merge columns of data

Merge Data into One Column

Sometimes I need to have a need to take columns of data in a spreadsheet and put them into one column. What I normally do, if it isn’t a lot of data, is use Control-X to cut out one column of data and put it underneath the other. However, why do this when you can press a button and have it do it for you.

columns into one column

Add-on Template


This is not an official Add-on for Google Sheets which means you will not find it by searching for more Add-ons. Instead, you must start from the provided spreadsheet template.

Sample Data

You will notice when opening up the spreadsheet that there are columns of names. This is so you can try out what the Add-on script does. Highlight any selection of data and press the “Start” button in the sidebar. This will take all of the values that are highlighted and combine them together into one list.

How Do You Use This

Since you must use my spreadsheet you need to figure out how to get your data into my spreadsheet. One option is copy and paste. You can add a new sheet and paste your data onto the new sheet. Another option is to click on the arrow on the tab of your data and choose “Copy to…” This will allow you to copy your data into my spreadsheet.

copy to from one spreadsheet to another

Uh Why

  • Lists of vocab words
    I have copied and pasted vocab words off the Internet, only to have to drag them into a list.
  • Collaborative spreadsheet
    Spreadsheets are great for brainstorming, sharing one with a group of students or colleagues everyone can put their ideas in every cell. Except, after the brainstorming you want the scattered ideas to be in a single list.
  • Merging rosters
    If you have multiple class sections you may want to get all the students in the same list.

Merge Columns

Merge Columns

© 2024 All Rights Reserved.

❤️ Become a Premium Teacher Tech Member

Regular price is $249. Save $150 and pay only $99 for the 2024/2025 school year!

Monthly installments is only $12 a month.

Exclusive Teacher Tech Content! 
Exclusive Online Courses
Premium Add-ons for Google Workspace
Office Hours with Alice
Weekly Check In Support
Exclusive Webinars
And more! 

Exit this pop up by pressing escape or clicking anywhere off the pop up.