I have a data set that shows numbers for categories over time. I would like to add the data label to the numeric value and then sort the data by the original number. Is this possible?

Here's an example



A 1 2 3 4
B 5 7 4 1
C 8 0 2 1
D 3 4 9 5


I would like each column sorted independently based on the data in that column, but I want the results to have the label from column 1 concatenated with the value in the other columns such as this:


A1 C0 C2 B1
D3 A2 A3 C1
B5 D4 B4 A4
C8 B7 D9 D5


Each column is sorted by the numeric value, but has the name label from column 1 attached to it.

Thanks for any help.