Column sort (1 Viewer)

[pl456]

Is it possible to sort columns horizontally?
i.e. you have 6 columns with 1,2,3,4,5 & 6 as a header number but they are not in sequential order.

 

[Brianwarnock]

Click Data Sort and then options, there is a sort left to right option.
Don't forget to select the whole area.

Brian

 

[pl456]

Spot on cheers.

 

[Brianwarnock]

Happy to help, especially as I didn't know till I looked, so I learnt something too.

Brian