I have a dynamic sized worksheet with the structure that each 6 columns has a date and then some data, in a specific order, in each column.
As it is now the top cell is just merged and the date is written, but any representation where the date is centered above the data would work.

What I need is to sort by date, but keep the structure underneath.

I.e. (with 3 instead of 6 and assuming Date1<Date2<Date3 are actual dates)

- Date1 - | - Date3 - | - Date2 - |
a1 b1 c1 | a3 b3 c3 | a2 b2 c2 |

Should become
- Date1 - | - Date2 - | - Date2 - |
a1 b1 c1 | a2 b2 c2 | a3 b3 c3 |

Thanks in advance.

ps. I am new to this forum, I don't know what tags to add.