Sorting data column wise

[chiswickbridge]

I have a database with the following...


Total Rows 101 and columns as dynamic...


Cells A1 and B1 is Text ( as header ), C1 to Z1 is date in dd-mm-yyyy format


Data in ColA is Text
Data in ColB is Text
Data in ColC is Numerals


The database is as follows...


A2 to B101 is Static and never changes...


The input starts with date in C1 and numerals in C2:C101.
Next day it starts in D1 and so on till Z1 and further.


The problem is that the input is not always in chronological order.


I need to streamline the project....by sorting C1 to about BZ1..in ascending order...with the subsequent data below...


That is, C1 will be the oldest date and and BZ1 or later will be the latest date ( say today )..


Thanks

 

[Yongle]

Finding it difficult to visualise what the data looks like and also how it should end up
- please provide some sample values

Before sorting
Q1 What is in C1:G1
Q2 What is in each cell
C2:G2
C3:G3
C4:G4

After sorting
Q3 What is in C1:G1
Q4 What is in each cell
C2:G2
C3:G3
C4:G4

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]Text A[/td][td]Text B[/td][td]Numerals[/td][td]Date1[/td][td]Date2[/td][td]Date3[/td][td]Date4[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]Text A-1[/td][td]Text B-1[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]Text A-2[/td][td]Text B-2[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]Text A-3[/td][td]Text B-3[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]