How to unpivot a table in Google Sheets easily

An easy trick that I discovered while trying to unpivot a table in google sheets was to use the array literal syntax. This syntax is close to how some programming languages deal with arrays and matrices. The only requirement to use this syntax in your google sheet is to have a manageable amount of columns that you can type manually in your formula.

--

--

--

Software Engineer. Starter of many unfinished things. Love hiking.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Designing ELT pipelines with dbt. (Part 1)

GSoC 2018 | Final Report

What is Heap in Data Structure

What is Heap in Data Structure

Spiral Model | Spiral Model in Software Engineering

SQL or NoSQL — Which one to choose ?

What Is an XML File? How Do We Use It in Data Validation?

Software We Pay For

Part 2: Unity ECS — project design

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Mohamed Elsharnouby

Mohamed Elsharnouby

Software Engineer. Starter of many unfinished things. Love hiking.

More from Medium

Google Sheets vs Excel — Who Comes Out on Top?

Google Sheets vs Excel - Who Comes Out on Top?

Top-5 best free word cloud generators

Geoanalytics in retail: how to choose the right location for a new grocery store?

Day 62: Solar System Scatter Plot