Forum Discussion

whateverletsgo's avatar
whateverletsgo
Copper Contributor
Jul 06, 2023

create multiple rows from one row of data

Hi,

 

I have data that looks like this 

 

and I want to copy the first cell down everytime column B or C or D is not equal to nothing. Like this 

excel

1 Reply

  • whateverletsgo's avatar
    whateverletsgo
    Copper Contributor
    Jul 06, 2023
    managed to get it working with an array arcument. thank you!
    It looks like this ={IF(IMPORT!C2<>"",IMPORT!A2,"");IF(IMPORT!D2<>"",IMPORT!A2,"")}

Resources