Combine multiple columns with values into another column

[Sajinjs07]

Hi,

Can someone please help me how to combine all column names with value to new column. I tried in virtual column and it shows result. But I wish to show in new column "Combined Column". Also blank value column names should not be shown. 

Example :

First Name: Ram

Middle Name:

Last Name: Raj

Result: First Name: Ram, Last Name: Raj

[jaichith · Accepted solution]

CONCATENATE(

If(isnotblank([description]),
Concatenate("Description: ", [Description]),""), "; ",
If(isnotblank([size]),
Concatenate("Size: ", [size]),"")

)

[Sajinjs07]

I really appreciate your quick response and understanding skills. Thank you so much. I tested and worked smooth. 

[jaichith]

Thank you