Sorting rows and columns.

Hi,

I need help creating a macro to be able to sort information by row and column.

Information that I receive is sorted by row and column, example:

Row:
1
2
3
4
5
6

Column:
a
b
c
d
e
f

The amount of rows and the amount of columns is variable depending on the job. Each row and column has a piece of information/height (variable figures). Is there a way to organise the information into 2 columns sorting by row, example:
1a
2a
3a
4a
5a
6a
1b
2b
3b
4b
5b
6b?

Can this be done?

Thank you.

Please provide a sample spreadsheet. It will help us figure out what you want and work out a solution.