Thread: How do I display list of only non-zero values and values that correspond to them?

Hi everyone,

I'm new here, please bear with me. I have a chart (see attached image for a made-up example) in which the rows are ingredients and the columns are different soil types. What I need to do is to automatically generate "recipes" for each soil type by showing only the ingredients for which a soil type has a nonzero value, and next to that, their values (the second attachment is what I'd like it to look like).

I think I need to use some sort of array formula, but I'm not totally sure what that is, and I definitely don't know how to write one.

Please help! Thank you in advance for your time/expertise.

Hello,

I'm SO sorry for not replying earlier, I had to put this project on hold for some time. Thank you so much for posting this-- unfortunately, I was hoping to do the reverse (meaning, I have the table on the bottom in your example, but I would like to automatically generate the one on the top).

Thank you for your help, and again, I apologize for taking *months* to respond. I wish there were an embarassed smiley I could use.

smdsi

Sure thing! I'd like to create easy-to-read recipes from the data in the sheet "chart I have." It should look like the second sheet "chart I want to generate." For each recipe, I'd like it to line up the quantity of each component next to the name of the component, but I would like it to *skip* any component with a quantity of zero. Does that make sense?

Thank you so much!

Have a look, see if this works for you.

Um, wow? This is so helpful, and so fast! Thank you!