FSA Tip #28 Merging Lists In Google Sheets

Today’s tip was inspired by an email I received wondering if there was a way to merge the crops lists from 3 separate crop plan into one list.

Well there is a pretty quick way to merge lists. And if you throw in the UNIQUE and SORT formulas you can organize your merged list to be a little bit easier to read.

In this tip, we’ll see …

  • You need to start with lists with the same number of columns
  • How to merge arrays with Curly Brackets {}
  • How to eliminate duplicates in the list with UNIQUE()
  • How to organize this list with SORT()
  • Why to be cautious of COMMAS
  • An example of merging Market Sales and CSA Contents to create a Vegetables Distributed List

You can get the spreadsheet from this tip to follow along at home.

What lists do you need to merge?


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s