Forum Discussion

Deleted's avatar
Deleted
Jul 10, 2018

copy cell to from different column using condation

Hello, 

could you help me, I need to copy data from the date and value column from each row into one column only those have value using cell formula that loop until 1st cell the last column is not = date

it should work as follows

if cell in value 1 > 0 then copy date1 and value1 to dateAll and ValueAll else loop to do this for date2 and value2 until no date. 

Date1
Value1
Date2
Value2
Date3
Value3
 
DateAll
ValueAll
28-Feb-2017
583
23-May-2018
691
05-Sep-2016
729
 
28-Feb-2017
583
31-Mar-2017
583
23-Jun-2018
691
05-Oct-2016
729
 
31-Mar-2017
583
30-Apr-2017
583
23-Jul-2018
0
05-Nov-2016
729
 
30-Apr-2017
583
31-May-2017
0
23-Aug-2018
0
05-Dec-2016
729
 
23-May-2018
691
30-Jun-2017
0
23-Sep-2018
0
05-Jan-2017
729
 
23-Jun-2018
691
31-Jul-2017
0
23-Oct-2018
0
05-Feb-2017
0
 
05-Sep-2016
729
31-Aug-2017
0
23-Nov-2018
0
05-Mar-2017
0
 
05-Oct-2016
729
30-Sep-2017
0
23-Dec-2018
0
05-Apr-2017
0
 
05-Nov-2016
729
31-Oct-2017
0
23-Jan-2019
0
05-May-2017
0
 
05-Dec-2016
729
 
 
 
 
 
 
 
05-Jan-2017
729
No Replies

Resources