So here is what I have: Substance Water Sodium Potassium Calcium Magnesium What I need is a formula that will concatenate only the non-zero's and the substance associated with them. For example this out put should say: Water, 98; Sodium .5; Potassium, 1; Calcium .5 If this seems pointless, the reason I need a methodology because I actually have about 50 substances and there are about 30 "quantity" columns and I would like a nice way to automate this and apply it to other similar applications. Thanks.
This question generated 23 answers. To proceed to the answers, click here.