How to unpivot a table in Google Sheets easily
2 min readNov 2, 2020
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.