Stack Multiple Columns

[bigfoot]

hi everyone. i have a sheet that has 190 columns populated, starting at column 'T'. each column is populated as follows.
row 1 numeric 1,2,3 or 4. only one of the four characters.
row 2 alpha could be one of A thru T. will be repeated
row 3 numeric 4 digit, will be a unique number
rows 4 thru 9 will contain alpha. at least one row will be populated, possibly up to 6 rows.
columns A, B, C and D will be labeled 1 thru 4

can someone please help me with a macro that will sort the 190 columns into the 4 columns.A thru D, first by the numeric, row 1, then by alpha, row 2, and all 4 digit numerics, row 3, within the alpha, and with the 6 rows below the numeric, associated with the numeric.
i appreciate any help that can be provided.

 

[bigfoot]

any thoughts?

 

[bigfoot]

bump

 

[obiron]

can you post some sample data of what it looks like and what the result should be - It is not clear from your description what you are trying to achieve