A
A
Alex2020-11-29 22:27:29
Google Sheets
Alex, 2020-11-29 22:27:29

How to add missing rows to a table?

A table is generated using QUERY, where one of the columns indicates the month in YYYY/MM format.
There are sometimes gaps in the returned data, the table is formed with missing months. How to add missing rows by adding missing months and assigning zeros to missing cells?

by converting this:
2020/01 | 443
2020/03 | 112
2020/05 | 244

in:
2020/01 | 443
2020/02 | 0
2020/03 | 112
2020/04 | 0
2020/05 | 244

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question