Autognerate rows and values

[Dan5]

I have a series of snapshots for a list of companies. Only changed values will appear in subsequent snapshots, and new companies can be added in new snapshots. This is great for db storage. 

What I would like to have, is a fully populated row for each company, for all subsequent snapshots after they first appeared. 

Meaning:

Company 1	Snapshot 1	value 1	value 2	value 3
Company 1	Snapshot 2	Value 1	null()	null()
Company 2	Snapshot 2	value 1	value 2	value 3
Company 1	Snapshot 3	value 1	null()	null()

Becomes:

Company 1	Snapshot 1	value 1	value 2	value 3
Company 1	Snapshot 2	Value 1	value 2 (from snapshot 1)	value 3 (from snapshot 1)
Company 2	Snapshot 2	value 1	value 2	value 3
Company 1	Snapshot 3	value 1	value 2 (from snapshot 1)	value 3 (from snapshot 1)
Company 2	Snapshot 3	value 1 (from snapshot 2	value 2 (from snapshot 2)	value 3 (from snapshot 2)

There is probably a more elegant way of describing this. Basically each company gets a fully populated row after they appear. If no new value is provided, take the last provided value for the row. 

I have maybe 10 value columns in my dataset, so simple workflow is best for upkeep. 

[AngelosPachis]

Hey @Dan5 ,

I have created a workflow that I think solved this issue. The multi-row formula tool will be your friend here.

Let me know if that worked for you

Cheers

Angelos

[Dan5]

Thanks, this is great!. However, what if there is no record for one company for one snapshot? Fx Company 2 has no row for snapshot 3, but appears again in snapshot 7 with a new value? How can i generate rows for each subsequent snapshot for a company after it first appears?