How to unpivot a table in Google Sheets easily

Mohamed Elsharnouby
2 min readNov 2, 2020
Pivot table icon

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.

--

--

Mohamed Elsharnouby

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