Forum Discussion
Solved
how can i conditionally move text? Probably IF/THEN
I have text in different columns essentially data is spread and I want to consolidate (dropping blanks). I have column A with numbers that tell me which other columns have text. For example A=1 m...
Since on;y one of the cells in columns D to F will be filled, you can use the following formula in M2:
=CONCATENATE(D2,E2,F2)
or if you have Excel in Office 2019 or Microsoft 365:
=CONCAT(D2:F2)
Fill down.
Since on;y one of the cells in columns D to F will be filled, you can use the following formula in M2:
=CONCATENATE(D2,E2,F2)
or if you have Excel in Office 2019 or Microsoft 365:
=CONCAT(D2:F2)
Fill down.
Thanks! this worked.