Hi Everyone!

I have a query related to concatenating several columns.

I have to make a product category path by concatenating categories from columns. each product is different and have different no. of categories, some has 1 category while others have 3, some have 4.

It will come up like this: Health & Beauty > Health Care > Biometric Monitor Accessories > Blood Glucose Meter Accessories

Above example there are 4 categories which are concatenate with ">".

Now, I know the concatenation formula, BUT I can only apply once I have a check whether category has value or not..

Looking forward to some guidelines in creating such formula.

Thanks,

Hamza