Hello
Is there an easy formula that can concatenate all cells in a column that contain data?
ie D1, D2, D4 and D17 all have data, the others in the column are blank so it returns just four results.
Also is there a way of returning these results in a list format?. ie if the results were apple, pear, orange, lime. I would want them to read like this in a cell
Apple
Pear
Orange
Lime
and not
Apple Pear Orange Lime
hope that makes some sense!.
thanks in advance
Is there an easy formula that can concatenate all cells in a column that contain data?
ie D1, D2, D4 and D17 all have data, the others in the column are blank so it returns just four results.
Also is there a way of returning these results in a list format?. ie if the results were apple, pear, orange, lime. I would want them to read like this in a cell
Apple
Pear
Orange
Lime
and not
Apple Pear Orange Lime
hope that makes some sense!.
thanks in advance