How to fill whole row above down in Multi-Row Formula

[whitkrieng]

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!

[JosephSerpis · Accepted solution]

Hi @whitkrieng I mocked up a workflow which I think will answer your question. Let me know what you think?

[Kenda]

Hi @whitkrieng 

I would recommend transposing the data first and make sure to use Date as a key column. After that, you'll want to sort it first by name then by date. From here, you should be able to fill the empty cells all at once because they'll all be in the Value column.

Hope this helps!

[cplewis90 · Accepted solution]

Hey @whitkrieng,

If you use a generate rows to add rows based on the dates, it should fill in all the other fields as it generates the new rows. Hopefully that works for you!

 

[whitkrieng]

Thank you!