How to remove empty columns and shift left data in bulk

Question

Hi Guys,&nbsp;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 Admin 1, 2 , 3 means move left.&nbsp;Admin1Admin2Admin3Admin4Admin5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;email address removed for privacy reasons&nbsp;email address removed for privacy reasons&nbsp;email address removed for privacy reasons&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;email address removed for privacy reasons&nbsp;&nbsp;email address removed for privacy reasons&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;email address removed for privacy reasons&nbsp;&nbsp;&nbsp;&nbsp;

riny_van_eekelen · Accepted Answer

vikrant_yadav&nbsp;Attaching a workbook that does what you need with Power Query. See if it is something you can apply to your real data.

Forum Discussion

How to remove empty columns and shift left data in bulk

2 Replies

Resources

Admin1	Admin2	Admin3	Admin4	Admin5




email address removed for privacy reasons	email address removed for privacy reasons	email address removed for privacy reasons









		email address removed for privacy reasons		email address removed for privacy reasons



email address removed for privacy reasons