Forum Discussion
Solved
How to remove empty columns and shift left data in bulk
Hi Guys, Need you help in removing empty cells and shift data to left. As you can see in below table, some data under Admin 3 column and some are under Admin5 , i want to move all data under Admi...
vikrant_yadav Attaching a workbook that does what you need with Power Query. See if it is something you can apply to your real data.
vikrant_yadav Attaching a workbook that does what you need with Power Query. See if it is something you can apply to your real data.
Thanks a lot Riny it's works for me.