I am trying to keep the first non null value and fill the rest down (2 rows) with blanks however I am finding it tricky with the multi row tool
E.g.:
| New |
| |
| LEAR & SMITH, 1/64 BARBER STREET, GUNNEDAH |
| 1/64 BARBER STREET, GUNNEDAH, WASTE REMOVAL SERVICES |
| WASTE REMOVAL SERVICES, 1 3m Waste removal + tip fees - 01/04/2021 $88.18 $97.00 |
| |
| |
| LEAR & SMITH, 1/64 BARBER STREET, GUNNEDAH |
| 1/64 BARBER STREET, GUNNEDAH, WASTE REMOVAL SERVICES |
| WASTE REMOVAL SERVICES, 1 3m Waste removal + tip fees - 01/04/2021 $88.18 $97.00 |
| |
| |
| LEAR & SMITH, 1/64 BARBER STREET, GUNNEDAH |
| 1/64 BARBER STREET, GUNNEDAH, WASTE REMOVAL SERVICES |
| WASTE REMOVAL SERVICES, 1 3m Waste removal + tip fees - 01/04/2021 $88.18 $97.00 |
| |
Expected output:
| New |
| |
| LEAR & SMITH, 1/64 BARBER STREET, GUNNEDAH |
| |
| |
| |
| |
| LEAR & SMITH, 1/64 BARBER STREET, GUNNEDAH |
| |
| |
| |
| |
| LEAR & SMITH, 1/64 BARBER STREET, GUNNEDAH |
| |
| |
| |