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

%3CLINGO-SUB%20id%3D%22lingo-sub-1590230%22%20slang%3D%22es-ES%22%3EGenerating%20a%20table%20when%20at%20least%20one%20of%20the%20elements%20of%20a%20row%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1590230%22%20slang%3D%22es-ES%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDear%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20this%20issue%20i%20need%20to%20solve%20and%20i%20can't%20just%20figure%20this%20out.%20Can%20you%20help%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20range%20of%20cells%20with%20different%20values%20and%20I%20need%20that%20when%20at%20least%20one%20the%20values%20of%20the%20range%20change%20a%20table%20is%20generated%20with%20this%20very%20same%20range.%20Then%2C%20when%20at%20least%20one%20of%20the%20values%20change%20again%20I%20need%20that%20range%20to%20be%20appended%20to%20the%20previous%20data%20in%20the%20table.%20The%20goal%20is%20to%20build%20a%20time%20series%20until%20there%20are%20not%20more%20changes.%20(Clearly%20the%20table%20must%20have%20as%20many%20rows%20as%20changes%20happened%20in%20the%20range%20plus%20the%20initial%20range)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1590230%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1590303%22%20slang%3D%22en-US%22%3ERe%3A%20Generating%20a%20table%20when%20at%20least%20one%20of%20the%20elements%20of%20a%20row%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1590303%22%20slang%3D%22en-US%22%3ESo%20each%20row%20has%20two%20values%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1590583%22%20slang%3D%22es-ES%22%3ERe%3A%20Generating%20a%20table%20when%20at%20least%20one%20of%20the%20elements%20of%20a%20row%20changes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1590583%22%20slang%3D%22es-ES%22%3E%3CP%3EHi!%20Each%20row%20has%20seven%20actually%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746148%22%20target%3D%22_blank%22%3E%40ramizassaf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22nicomateos_0-1597496827258.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F212601iE6A450451ABF9FCB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22nicomateos_0-1597496827258.png%22%20alt%3D%22nicomateos_0-1597496827258.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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