Matrix with different datatypes (picture, number, text)

Hi@ gaj

After my research, you can use sort by function and do these follow my steps like below:

Step 1:

Rename column in Edit Queries

Format: ’decimal number’+’ ’+’title’

I recommend use ‘ ’ as delimiter

For example

Be care for that there is one ‘ ’ between ’decimal number’ and ’title’

Step 2:

Unpivot columns

Step 3:

Select column Attribute and then click  Add Column->Extract->Text Before Delimiter

Entry “ ” click OK

Step 4:

Change the type of column Text Before Delimiter to Decimal Number and then Click Close&Apply

Step 5:

Drag fileds into table then select filed Attribute click Modeling->Sort ->Sort by Column -> Text Before Delimiter

Result:

Best Regards,

Lin