Horizontal and vertical criteria ranges + vlookup multiple conditions?

Hey guys,

I would really appreciate som help on this problem.

The workbook shows the structure of my database to the left, and to the right how i would like to restructure the data.

The main problem is being able to transpose the data with multiple criteria ranges on date, id, segment and m.

Anyone have any ideas? Im guessing that I will be needing some kind of multiple conditions vlookup, matrix or something like that.

Best regards

Lukas