Forum Discussion

Copper Contributor

Jan 11, 2022

Fill cell with value

How to fill E column with cell with data from A to D column. ABCD column will only consist of one data for

Diamond Contributor

Jan 11, 2022

As variant

=FILTER( A1:D1, A1:D1 <> "" )