Forum Discussion
Sameer_Kuppanath_Sultan
Nov 22, 2021Brass Contributor
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...
- Nov 22, 2021
Sameer_Kuppanath_Sultan Consider Power Query for such a task. See attached.
Riny_van_Eekelen
Nov 22, 2021Platinum Contributor
Sameer_Kuppanath_Sultan Consider Power Query for such a task. See attached.
Sameer_Kuppanath_Sultan
Nov 24, 2021Brass Contributor
Its a small part of a big project in excel, thanks IT WORKED!!!