Shift Header cells left G&T

[Melimob]

Hi there

I have a report where the data is under the wrong headers.
I have demoted header row and I simply want to delete one cell to move the cells left then promote again but can't find how to do this?

Appreciate any advice.

Many thanks

 

[citizenbh]

in Excel, select header's cells and move everything to the left or right