Dear Experts,

                     I have a Table as in the “Input” Sheet, and want to make a Table as in the “Output” Sheet.

as below:-

Could you please help share the power query function or the “M Query” or the Legacy Excel formulae which can achieve this?

Basically , deleting all the empty cells in the input and shifting those cells up can do the job, but now sure how to achieve this.

Thanks in Advance,

Br,

Anupam

​Dear Experts,                     I have a Table as in the “Input” Sheet, and want to make a Table as in the “Output” Sheet.as below:-Could you please help share the power query function or the “M Query” or the Legacy Excel formulae which can achieve this? Basically , deleting all the empty cells in the input and shifting those cells up can do the job, but now sure how to achieve this. Thanks in Advance,Br,Anupam  Read More

​