Unifying data in multiple columns into a single column in Google Sheets

A common application is when you’re trying to create a list of all values that a data point can have, but when the data is entered across multiple columns. For e.g., imagine color variants of a product split across columns named Color 1, Color 2, Color 3, and so on. This formula will help list all the possible colors that the product can have.

It is simple when the data is as simple as is in this picture, but it gets more complex with more context! So be ready for some hiccups when you actually try and use it in your work.

#data #analytics #GoogleSheets #gsuite #tipsandtricks #dataanalytics

Leave a Reply

Please log in using one of these methods to post your comment:

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