I'm running the following forumula:
= IF (INDEX (C $ 2: US $ 2, 1, ROW (1: 1))), CONCATENATE (C $ 2.00, "-", INDEX (C $ 1: 1, 1, ROW (1 : 1)))))
On the following table
Basically, if a value is present in column C2, I return the value + the value of B2. I'd like to do this for all columns up to O2, however, once I reach the O2 column, I'd like to go to the next line and have the process start with a new one. line. How would I do that?