Forum Discussion

Sameer_Kuppanath_Sultan's avatar
Sameer_Kuppanath_Sultan
Brass Contributor
Nov 22, 2021
Solved

Arranging data in row from multiple columns by avoiding Zeroes.

Hi All

Greetings..

 

I have a data set below. 

I would like to arrange it in row by avoiding "0"s in cells like down below. 

Is there any formula I can use to do this process. I have attached the excel also for the reference. 

Resources