Help convert a table/range into another

[Nunoalex]

Hi everyone!

First of all thank you so much to all the persons that go out of their way and are here to help others and share their expertise
It is really noble that people spend their time and resources to help others.. there is hope for this world yet

I too try to help a little bit on some fields where I can, like electronics and old computer like the Vogons forum...

anyway I would like to ask if there is a simple way to convert a excel table (or data range) into another

In my company I work with schedules and the departments send me schedules in a format that is very difficult for me to use and I would like to have a simple automated tool to convert the data
Basically I need to extract unique values from the data and make a list of them and convert row "hearers" into data

Here is an example sheet of what I am talking about


Thank you very much

Nuno