Spreadsheet: 148224d1333265352-formula-macro-needed-for-merging-cells-and-moving-related-data-transaction_description_merge_all_data_to_1_row
Sheet: Sheet1

1 |  | Transaction Description | MoneyOut | MoneyIn | BALANCE |  |  | 1 |  | Transaction Description | MoneyOut | MoneyIn | BALANCE
2 |  |  |  |  |  |  |  | 2
3 | 2007-12-31 00:00:00 | INTEREST PAID |  | 0.05 | 6375.09 |  |  | 3 | 2007-12-31 00:00:00 | INTEREST PAID |  | 0.05 | 6375.09
4 | 2007-12-31 00:00:00 | MERCHANT SETTLEMENT |  |  |  |  |  | 4 | 2007-12-31 00:00:00 | MERCHANT SETTLEMENT 0920001 HANDYWAY HAIRPOWER 0001 SOUTHPORT |  | 510 | 6885.09
5 |  | 0920001 HANDYWAY |  |  |  |  |  | 5
6 |  | HAIRPOWER 0001 |  |  |  |  |  | 6
7 |  | SOUTHPORT |  | 510 | 6885.09 |  |  | 7
8 | 2007-12-31 00:00:00 | MERCHANT SETTLEMENT |  |  |  |  |  | 8 | 2007-12-31 00:00:00 | MERCHANT SETTLEMENT 0940001 HANDYWAY HAIRPOWER 0001 SOUTHPORT |  | 1900 | 8785.09
9 |  | 0940001 HANDYWAY |  |  |  |  |  | 9
10 |  | HAIRPOWER 0001 |  |  |  |  |  | 10
11 |  | SOUTHPORT |  | 1900 | 8785.09 |  |  | 11
12 | 2007-12-31 00:00:00 | WITHDRAWAL - INTERNET |  |  |  |  |  | 12 | 2007-12-31 00:00:00 | WITHDRAWAL - INTERNET ONLINE BANKING 1539048 PAYMENT 2 weeks rent #504 31-DEC | 1130 |  | 7655.09
13 |  | ONLINE BANKING 1539048 |  |  |  |  |  | 13
14 |  | PAYMENT 2 weeks rent |  |  |  |  |  | 14
15 |  | #504 31-DEC | 1130 |  | 7655.09 |  |  | 15
16 | 2007-12-31 00:00:00 | PAYMENT BY AUTHORITY TO |  |  |  |  |  | 16 | 2007-12-31 00:00:00 | PAYMENT BY AUTHORITY TO WESTPAC BANKCORP DIRECT DR148474711 | 1117.15 |  | 6537.94
17 |  | WESTPAC BANKCORP |  |  |  |  |  | 17
18 |  | DIRECT DR148474711 | 1117.15 |  | 6537.94 |  |  | 18
19 | 2008-01-02 00:00:00 | 02JAN MERCHANT CHARGES |  |  |  |  |  | 19 | 2008-01-02 00:00:00 | 02JAN MERCHANT CHARGES HANDYWAY MONTHLY FEE | 25.28 |  | 6512.66
20 |  | HANDYWAY MONTHLY FEE | 25.28 |  | 6512.66 |  |  | 20
21 | 2008-01-02 00:00:00 | 02JAN TRANSACTION FEE | 17.8 |  | 6494.86 |  |  | 21 | 2008-01-02 00:00:00 | 02JAN TRANSACTION FEE | 17.8 |  | 6494.86
22 | 2008-01-02 00:00:00 | 02JAN SERVICE FEE | 8 |  | 6486.86 |  |  | 22 | 2008-01-02 00:00:00 | 02JAN SERVICE FEE | 8 |  | 6486.86
The above is how the bank statements appear when exported |  |  |  |  |  |  |  | I would like a macro/formula to merge the transaction description to one line as shown above.
 |  |  |  |  |  |  |  | I would like a macro/formula to move the $amount to be on the same row as the date and Transaction Desription.
 |  |  |  |  |  |  |  | Then I would like it to delete the empty rows eg rows5,6,7,9,10,11,13,14,15,17,18 & 20 above.
 |  |  |  |  |  |  |  | So the bank statement would end up looking like this example below:
 |  |  |  |  |  |  |  | 1 |  | Transaction Description | MoneyOut | MoneyIn | BALANCE
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 3 | 2007-12-31 00:00:00 | INTEREST PAID |  | 0.05 | 6375.09
 |  |  |  |  |  |  |  | 4 | 2007-12-31 00:00:00 | MERCHANT SETTLEMENT 0920001 HANDYWAY HAIRPOWER 0001 SOUTHPORT |  | 510 | 6885.09
 |  |  |  |  |  |  |  | 5 | 2007-12-31 00:00:00 | MERCHANT SETTLEMENT 0940001 HANDYWAY HAIRPOWER 0001 SOUTHPORT |  | 1900 | 8785.09
 |  |  |  |  |  |  |  | 6 | 2007-12-31 00:00:00 | WITHDRAWAL - INTERNET ONLINE BANKING 1539048 PAYMENT 2 weeks rent #504 31-DEC | 1130 |  | 7655.09
 |  |  |  |  |  |  |  | 7 | 2007-12-31 00:00:00 | PAYMENT BY AUTHORITY TO WESTPAC BANKCORP DIRECT DR148474711 | 1117.15 |  | 6537.94
 |  |  |  |  |  |  |  | 8 | 2008-01-02 00:00:00 | 02JAN MERCHANT CHARGES HANDYWAY MONTHLY FEE | 25.28 |  | 6512.66
 |  |  |  |  |  |  |  | 9 | 2008-01-02 00:00:00 | 02JAN TRANSACTION FEE | 17.8 |  | 6494.86
 |  |  |  |  |  |  |  | 10 | 2008-01-02 00:00:00 | 02JAN SERVICE FEE | 8 |  | 6486.86
 |  |  |  |  |  |  |  | The above example would be the final result