Forum Discussion
Solved
Best way to populate 1 cell with a summary of several previous cells in the same row?
Hello, I have data in some columns but not others, [data from bagel shop customers selecting their cream cheese options for orders]. What is the best way to populate 1 cell at the end of the row to ...
As an array formula confirmed with Command+Return:
=TEXTJOIN(", ",TRUE,IF(A2:F2>0,A2:F2&" "&A$1:F$1,""))
Adjust the ranges if needed.
As an array formula confirmed with Command+Return:
=TEXTJOIN(", ",TRUE,IF(A2:F2>0,A2:F2&" "&A$1:F$1,""))
Adjust the ranges if needed.
That is perfect - many thanks!! HansVogelaar
