Sort a column by another column principle

[Anonymous]

Hi everyone, I have a table like this 

I would to visual a table with Parent_Index and Index as Column Label like this 

I want to sort weekday in order so I create the Order_id columns, but I can not sort Index Column by  Order_id columns

I just do not really understand why I am wrong and how to done it. 

I will be appreciated for your help. Thanks in advance!

[lbendlin · Accepted solution]

Add a composite key (Index+parent index) and change the order_id column to consecutive numbers across that composite key as needed.

[Anonymous]

But when it comes for visualizing, I still want to use column "Index" and "Parent_Index" seperately for visual's column labels. Creating composite key and sorting it by distinct consecutive order_id seem not really help. 

[lbendlin]

You can still do that. Try in out.

[Anonymous]

It worked!! So sorry for late response.
Thank you very much.