I have a table like so: - it has some blanks
|V1||B1 0/1||C1 0/0||A1 1/1||-|
|V2||C1 0/1||A1 0/0||B1 0/1||-|
|V3||B1 0/0||A1 0/1||-|
I would like to shuffle each row around so they fall in the correct column, so in a way sort across rows but not move the data vertically, only horizontally as each row is specific to the V number.
How would I do this in calc?
EDIT: table format applied by LeroyG, following erAck link.