Forum Discussion
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
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,"")}
It looks like this ={IF(IMPORT!C2<>"",IMPORT!A2,"");IF(IMPORT!D2<>"",IMPORT!A2,"")}