Excel Formula/Macro: Fetch data from multiple rows and columns with a single key

[needhelpalwa]

I have a data-set like this which keeps adding every week-

22773

The actual table has 44 columns and every week I make a summary from it for the data that week I tried Vlookup by date (taking 20th Aug as key) but that stops just at the first instance of finding 20th August. Is there an effective way to do this with VBA or any other excel formula which I am missing? This is the sample output-

This is the output (sorted) date wise (https://i.stack.imgur.com/PVJCA.jpg)

22772

[Paul_Hossler]

If there were an atachment with the data in it, I'd have have experimented with a pivot table to see how close I could get to the desired format

But making a PT would be the easiest way probably. There's many layout and display options