I don’t get what you intend to reach, but in case you want to have the value in the complete column check the “fill” transaction, which you can add after the “if” transaction to fill the column with the value. But the typical use of if is, as in Excel, to get the value of the row in that column where the conditions are met.
If Fill doesn’t help you should show with a concrete example, use the table, what you intend to do.
Sorry my explanation isn’t clear. I want the value in cell A1 (circled in the above image) to get copied into a column. So i can than make an unique value using the dispatch number from A1 and the X and Y column.
I have now managed to get the value i wanted into a column, using filter, new row, row number and then the join function. Which i can now manipulate to get the unique value i need. However this might be the best way to do it.