Sorting two level column

[MoxieMeister]

Hi all,

I have some problems with sorting in the column name levels.

My try is:

 But necessary make like this:

Cannot swap columns level.

 Is it possible?

Thanks.

[Anismohamed32]

Hi ,

You can sort the column at your own wish , by having if condition in the sorting tab.

1. click the sort option
2.write if condition by selecting the option set by expression.
3. if condition example :
=if(group='M27',1,
if(group='Axis',2,
if(group='Black',3,
if(group='GSC',4,
if(group='T3',5,
if(group='TDM,6,7)

[MoxieMeister]

Hi,

The basic idea of sorting is to ignore the sorting of the first header.

In this case, test data is presented. In the original, data is added dynamically.

Accordingly, this 'If' does not universal approach.

Thanks.

[Anil_Babu_Samineni]

Try this as a Sort by expression

Match(Group, 'M27','Axis','Black','T3','TDM')

If not, Create Mapping field in the script with some serial no to form same as that field