Goal here is to have the sheets search a row, then once it finds the first instance of >=0, return the cell value that contains the month+concatenate the value in the cell next to it (or any other cell of choice). I've confirmed I can do this with a series of nested IF statements, but am looking for something more efficient. I'm not too terribly familiar with writing my own scripts, but can if someone can give general direction.
From rev 1:
Please note that the month is above the value.
$C1:$1refers to the headers row
C2:2refers to the values row.
IFreturns an array where values equal and greater than 0 are included and blank is included for values that are less than 0.
JOINcreates a string using a comma to separate array values.
SPLITsplits the string omitting the blank members.
INDEXreturns the first member.