I have a 50,000 row spreadsheet with 56 columns. The item in Col A Row 5
repeats in rows 6, 7, 8, 9 and 10 (all Col A). There is data in cells
(Row/Col) 5/B, 5/D, 6/L. 6/Z, 7/AH, 8/AP, 9/AR, 9/AT and 10/AW.

I want to move the data from cells 6/L, 6/Z, 7/AH, 8/AP, 9/AR, 9/AT and 10AW
to cells 5/L, 5/Z, 5/AH, 5/AP, 5/AR, 5/AT and 5AW.

There will never be a cell in row 5 that will contain data that will be
written over by moving the data from rows 6, 7, 8, 9 and 10.

In this way I will reduce the 50,000 rows to a more manageable 10,000 or so.
I have tried importing into Access but there are too many columns to allow me
to run a query or report.

Many thanks