Forum Discussion
Solved
Create a list of columns with value per row
Subject probably makes no sense so let me explain with an example: A.1 A.2 A.3 A.4 A.5 A.6 A.7 A.8 DESIRED RESULT #001 1 3 4 A.1, A.4, A.5 #002 ...
=BYROW(B2:I9,LAMBDA(row,TEXTJOIN(",",,FILTER(B1:I1,NOT(ISBLANK(row))))))You can try this formula.
=TRANSPOSE(BYCOL(Assessment!L7:CZ130,LAMBDA(column,TEXTJOIN(",",TRUE,FILTER(Assessment!A7:A130,NOT(ISBLANK(column)))))))I am unsure if i correctly understand how your data is actually laid out. I've tried to replicate the layout of the data and this formula could return the expected result.
Sheet "SOA":
Once again, thanks very much for your assistance ! Transpose worked a treat.
As background, the formula is being used in a risk assessment spreadsheet whhich now details the controls selected per risk and the risk associated with each control. These provide a direct link between risk assessment and risk treatment/security controls and help support audit and assessment of the risk process.
As background, the formula is being used in a risk assessment spreadsheet whhich now details the controls selected per risk and the risk associated with each control. These provide a direct link between risk assessment and risk treatment/security controls and help support audit and assessment of the risk process.