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 attached the excel also for the reference.
Sameer_Kuppanath_Sultan Consider Power Query for such a task. See attached.
2 Replies
- Riny_van_EekelenPlatinum Contributor
- Sameer_Kuppanath_SultanBrass ContributorIts a small part of a big project in excel, thanks IT WORKED!!!