Forum Discussion
Add missing line
My suggestion is to import the data in such way.
E.g. Create a qry / Maintain another table with all the values (customer and four months with the zero value) and merge it with the table which has data.
My suggestion is to import the data in such way.
E.g. Create a qry / Maintain another table with all the values (customer and four months with the zero value) and merge it with the table which has data.
Thank you for your answer !
I did what you told me to, but when I merge, I get 4 rows per customer, multiplied by the number of active months...
Show me a sample of the format you want your data
Actually, I finally managed to have what I was looking for, thanks to your instructions and a few more google searches.
But now I'm struggling to fill in the "null" lines, since I cannot use fill up nor fill down (both would give me wrong values), and I don't really know what to do next.
I'm currently trying using an index and some formula to only fill down if the value on the id column is the same as the value on the id column but one row above.
Maybe you can help too ?
Thank you very much