Excel Formula to create an organized Data Sheet from an unorganized one.

Hi,

I am practicing and I am just stuck with a problem if we have an unorganized list given to us

(as it is given below).


problem .png




So as you can see the Raw data is from (A1 - O5) and has multiple matching headers from (A1 - O1).

Now I want to create a formula so that all this data is organized inside (P2 - T5) based on their headers (P1 - T1) as below:

solution.png


please help me to find the solution