Can you use a Vloopup with a Transpose function?

Is it possible to use a Vlookup function to search name in a table and return the volumes by day transposed to a separate file? I cannot seem to get the Vlookup to work with the transpose function.

I have attached two small files as examples.

If you can help me I would be very grateful.

Thank you so much for your time.

AttachmentSize
Table.xlsx9.24 KB
Output file.xlsx9.47 KB

Vlookup with Transpose

It can be done in two steps, using a third, intermediate array. I don't immediately see a way to do it with a single nested function.
I'll check back on this tomorrow. If you or someone else has not posted a solution, I'll finish and send mine.
Good luck, and thanks for the puzzle!