I have a bank statement with some entries like this.
As you can see, the description is split vertically into 2 cells in 2 different rows and the amounts/credit or debit come in the lower row as well.
I need a macro that will detect all cells with missing dates in column A, then shift all data in that correspondent row to the row above and then delete the blank row when the data is shifted up so each transaction in the sheet comes in 1 row with all details in the same row.
Help
Bookmarks