Combinding column values

[Romano_odK]

Good morning,
Trying to combine cells from a row when they have a value. For example when cell C2 is filled which is in this case "cloud", G2 should say : update items set Userfield_02 ="cloud" where itemcode is A2. When there are more then one cell filled in the row cell G2 should say: update items set Userfield_01 ="car", Userfield_02 = "cloud" where itemcode is A2. This is bit too much for me to accomplish and also I do not know if it possible. The komma is also a problem because you need it after every filled cell. Is there a way to do this?

Thank you for your time,

Romano

Itemcode	Userfield_01	Userfield_02	Userfield_03	Userfield_04	Userfield_05
100000​	car	cloud	vacation	forward	minute
100001​
100002​
100003​
100004​
100005​
100006​
100007​
100008​
100009​
100010​
100011​
100012​
100013​

 

[Fluff]

How about

=TEXTJOIN(", ",,IF(B2:F2<>"",B1:F1&"="&B2:F2,""))

 

[Romano_odK]

How about

=TEXTJOIN(", ",,IF(B2:F2<>"",B1:F1&"="&B2:F2,""))

Good afternoon,

This approach seems to be the solution. Thank you and have a great day.

Romano

 

[Fluff]

You're welcome & thanks for the feedback.