Create a : deliminated string from titles of array of data, depending on if a value exists

Hello,

I have a problem, in that I have rows of data some with values in, some without and some rows with data in multiple colums. I need to create a string of data in a colon ( deliminated format with no colon at the end by checking if a row has any data in a specific colum, if it does take the column name/title and add it to the string of data which would sit in the variant name column in the example data I have attached. Where there is no data for a row in a specific column these need to be ignored and go onto the next colum.

I also need it to be possible to expand the number of colums, either by editing any code or simply by incerting a column. The number of rows I would need to do this to would be aproximatly 10000.

I would be very greatful for any help you can provide.

Best regards,

Paul