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

Occasional Contributor


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 Replies
best response confirmed by Hans Vogelaar (MVP)


You can try Power Query.

day product.JPG

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!