show the unordered data of multiple columns in one sheet arranged in another sheet

[Stefaan_DM]

Hello, 

suppose you have a number of products, some of which you have to administer chronologically one to several times.

You make a table where, depending on the customer, you fill in the days for the products he uses. 

But you want to show this nicely automatically arranged chronologically in a second sheet. Only the products he uses.

Is this possible ?

[#2 · Accepted solution]

@Stefaan_DM 

You can try Power Query.

[#3]

I had never heard of "power query" before so I looked it up; Apparently you can do a lot with it and I'll have to look into it. Anyway it works ; thanks a lot!