title: Taking a group of cells and organizing them into a comma separated list in a single cell, arranged in order of percentage in google sheets
body: <p>Google sheets problem here. I have a group of cells that I'm trying to automate into making the &quot;ingredient list&quot; in a nutrition facts cell for food products. I'll have in one row for example, carrots, onion, tomatoes, sugar. In the cell next to it, I'll have the corresponding percentage. What I need, is to have each item sent to a single cell so that it looks like a plain sentence. For example, if the info was carrots 22%, onions 33%, tomatoes 12%, and sugar 5%, the information would read &quot;Ingredients: Onions, Carrots, Tomatoes, Sugar. Thank you in advance for your help. This one has been giving me a headache.</p>
  <p><a href="https://i.stack.imgur.com/cwv5d.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cwv5d.png" alt="Sample Sheet" /></a></p>
  <p>Here is a screenshot of my current sheet. As you can see, there are the two circled columns and the arrow pointing to the &quot;ingredients&quot; cell. I need the cells that are circled to be listed in the &quot;ingredients&quot; cell in order of percentage from highest to lowest, separated by commas.</p>
  <p><strong>Update:</strong> I have been able to figure out how the list the cells, but I can't figure out how to organize them by percentage. Here is the formula I'm currently using.</p>
  <p>=CONCATENATE(F2,&quot;,&quot;,F3,&quot;,&quot;,F4,&quot;,&quot;,F5)</p>
  <p><a href="https://i.stack.imgur.com/7pGL6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7pGL6.png" alt="enter image description here" /></a></p>