I have a spread sheet. Across the top row are the column headings. In each row (column BL) is were I want the formula. If you view cells in each row below the heading many are blank and some have text and some a percent value. In Cell BL2 for instance I want a formula that looks across cells BS2:DN2 and ignores the blanks ones, but kind of concatenates the non blank ones with the column Heading.
I was hoping for a concise array formula that maybe uses the join capability ("|"), but not sure if that's the right avenue.
Any helpful ideas are welcomed!
Chip
I was hoping for a concise array formula that maybe uses the join capability ("|"), but not sure if that's the right avenue.
Any helpful ideas are welcomed!
Chip