Sorting Columns left2right by heading to fit a list


This is probably quite easy ….

I have columns with headings (headings denoted by H*, cells in table by lettes a, b, …….)


H1 H2 H3 ….. Hn

a1  a2  a3 ….. an

b1  b2  b3 ….. bn


I have a heading list with another order, say :

H8 H5 Hn …. H3


I need to reorder the column in the first table so that it has the exact same order as the latter list (H8 H5 Hn …. H3).

By: Stein Grongstad

Leave a Reply

Your email address will not be published. Required fields are marked *