Sort selected columns by row

Question

In Numbers, how is it possible to sort selected columns by a row? In the following example I want to sort the columns B, C and D by using the values in row 1.

So far, I have only found the reverse action (which does what it is supposed to) "sort selected rows by column".

Answer 1

Transpose the sheet (Table->Transpose rows and columns), sort, and then transpose back. However you may lose some of the formatting, like column widths and row heights.