I have this excel file and I would like to delete all blank cells in columns A and shift the populated cells up using python.
Not sure how to do this, any advice? I know I can go into excel and do it manually but I need to automate this process. Multiple files looking just like this will be created, and I need to automate adjusting this so that all those populated cells in column A actually sit next to the rest of the data in B, C, D, E.