I need help filling in the missing row with the above row. Example dataset is like this:
| | Store | A Field | B Field | C Field |
1/1/2016 | Store A | A | B | C |
3/1/2016 | Store A | A | B | C |
5/1/2016 | Store A | A | B | C |
7/1/2016 | Store A | A | B | C |
9/1/2016 | Store A | A | B | C |
10/1/2016 | Store A | A | B | C |
11/1/2016 | Store A | A | B | C |
12/1/2016 | Store A | A | B | C |
5/1/2017 | Store A | A | B | C |
6/1/2017 | Store A | A | B | C |
7/1/2017 | Store A | A | B | C |
9/1/2017 | Store A | A | B | C |
10/1/2017 | Store A | A | B | C |
11/1/2017 | Store A | A | B | C |
12/1/2017 | Store A | A | B | C |
4/1/2018 | Store A | A | B | C |
5/1/2018 | Store A | A | B | C |
6/1/2018 | Store A | A | B | C |
7/1/2018 | Store A | A | B | C |
8/1/2018 | Store A | A | B | C |
10/1/2018 | Store A | A | B | C |
11/1/2018 | Store A | A | B | C |
12/1/2018 | Store A | A | B | C |
1/1/2019 | Store A | A | B | C |
2/1/2019 | Store A | A | B | C |
3/1/2019 | Store A | A | B | C |
4/1/2019 | Store A | A | B | C |
5/1/2019 | Store A | A | B | C |
So once the dates are incremented using say Generate Rows, it’ll look like:
| | Store | A Field | B Field | C Field |
1/1/2016 | Store A | A | B | C |
2/1/2016 | | | | |
3/1/2016 | Store A | A | B | C |
4/1/2016 | | | | |
5/1/2016 | Store A | A | B | C |
For 2/1/2016 I’ll need to fill in the WHOLE row above. If i have a lot of columns, I don't want to insert every single one into the Multi-Row formula. Any help would be appreciated.
Thanks!
