I am running the following forumula:

=IF(INDEX(C$2:$2, 1, ROW(1:1)),CONCATENATE(B$2,"-",INDEX(C$1:$1, 1, ROW(1:1))))

On the following table

Basically, If a value is present in column C2, I am returning the value + the value of B2. I would like to do this for all the columns up to O2, however, once I reach column O2, I would like to move to the next row and have the process start with a new row. How would I do this?


 IF(C2:O<>"", "♦"&B2:B&"-"&C1:O1, )),,999^99)),,999^99), "♦"))))


  • 1
    Appreciate it! Any chance you can share some insight into how you came up with this? Just to add on, I would like to not return a value if no value is present in a row, so for F2, I would like to return false. – user222813 Jul 12 at 19:06
  • =ARRAYFORMULA(TRIM(TRANSPOSE(SPLIT(QUERY(TRANSPOSE(QUERY(TRANSPOSE( IF(C2:O<>"", "♦"&B2:B&"-"&C1:O1, "♦FALSE")),,999^99)),,999^99), "♦")))) – user0 Jul 12 at 21:00
  • sadly, even if the answer solved the OP's issue, it got downvoted by someone who couldn't come up with the solution and OP can't accept it from the new account – user0 Jul 12 at 23:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy