Best way to populate 1 cell with a summary of several previous cells in the same row?

Question

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 summarize everything the user entered in the entire row, including the item name for each entry [which is in the row above], but also skip/ignore any blank entries?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; E&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GCup of PlainPint of PlainCup of Cinnamon SugarPint of Cinnamon SugarCup of Garlic CreamPint of Garlic CreamSummary1&nbsp;2&nbsp;&nbsp;&nbsp;1 Cup of Plain, 2 Cup of Cinnamon Sugar&nbsp;I was using Google Sheets and had a formula that worked there, but I can’t replicate in Excel.Thanks!Lindsey&nbsp;&nbsp;[My google sheets question that resulted in the formula I was using are here: https://support.google.com/docs/thread/40080675?hl=enIdea of the formula:=TEXTJOIN(", ", TRUE, ARRAYFORMULA(IF(LEN(E2:M2),CONCAT(E2:M2,CONCAT(" ", $E$1:$M$1)), )))]

hansvogelaar · Accepted Answer

gindseylaudet&nbsp;
As an array formula confirmed with Command+Return:
&nbsp;
=TEXTJOIN(", ",TRUE,IF(A2:F2&gt;0,A2:F2&amp;" "&amp;A$1:F$1,""))
&nbsp;
Adjust the ranges if needed.

Forum Discussion

Best way to populate 1 cell with a summary of several previous cells in the same row?

2 Replies

Resources

Cup of Plain	Pint of Plain	Cup of Cinnamon Sugar	Pint of Cinnamon Sugar	Cup of Garlic Cream	Pint of Garlic Cream	Summary
1		2				1 Cup of Plain, 2 Cup of Cinnamon Sugar