Generating a table when at least one of the elements of a row changes

Copper Contributor

 

Dear all,

 

I have this issue i need to solve and i cant just figure this out. Can you help me?

 

I have a range of cells with different values and I need that when at least one the values of the range change a table is generated with this very same range. Then, when at least one of the values change again I need that range to be appended to the previous data in the table. The goal is to build a time series until there are not more changes. (Clearly the table must have as many rows as changes happened in the range plus the initial range) 

 

Thank you very much! :)

2 Replies
So each row has two values?

Hi! Each row has seven actually @Ramiz_Assaf 

 

nicomateos_0-1597496827258.png