Sort rows with duplicated values in matrix

My task is to concatenate tables from different excel files into one big csv file, then recreate those tables in Power BI Matrix with different slicers. However, rows in each table must preserve its order in the original table, if i simply create another column with row order and sort with it, power BI doesn't allow this because there is duplicated rows and their row order is different. Here is a sample csv data concatenated from two excel files, one records product from company A and the other records product from company B:

company,product,sold_location,value,row_order
A,carrot,Mars,100,0
A,apple,Mars,200,1
B,banana,Earth,300,2
B,apple,Earth,400,3
B,carrot,Earth,500,4

I need to preserve the order of product within each company. I've been following this solution: https://community.fabric.microsoft.com/t5/Desktop/Sorting-matrix-table/m-p/4356730#M1361290

i.e create an invisible column with empty space char, repeated with the values in row_order:

and put company, invisible column, and product in Rows field so that product can be sorted by invisible column:

All good now, but the drawback is this invisible column still shows and can be clicked:

 Is there a way to remove this level of hierarchy?

Finally, in general what is the best way to preserve original excel table row order? I'm very new to Power BI and didn't expect it to be this complicated. Thank you for any help!