How to sort a table

Hi all, i am looking for a solution to arrange a table, this seems not that difficult but I hit a snag.   There is the point: - x lines with AA, BB, CC,... values - y column with A, B, C, D,... ...