Dear Ivan,
thank you for your quick response. I did it via String to number and it worked just fine, but when I wanted to visualize the data via histogram and assign a colour to a number I could not because it would be shown as a range, and the lowest values has like colour red and the highest one has a blue.
But nevertheless, what I am trying to do is to sort data so that in the end i got them like sorted hierarchically like phylogenetic tree.
I have families of certain transporters and every family has a subfamily. There are structures that bind to certain transporter. The idea is to have a families like main group branching into corresponding subfamilies, branching to compounds that are binding to them, branching to a certain value which is specific tot that compound.
I managed to get something that resemble to the phylogenetic tree using a parallel coordinates plot, but still my families and subfamilies are not ordered in a way that i want them to be, so the plot itself resemble to the phylogenetic tree but it is not the one.
i would like to have them like
R1 branches to R1.1
R1.2
R2 branches to R2.1
R 2.2
R 2.3
etc.
instead i have
(there is a name and a number of a certain transporter)
R1 R3.1
R2 R1.1
.
.
.
thank you