Hello all, hope you can help!

Here is my dilema. i have a raw data that is formatted like this

group type value1 value2

group a new 1 1
group a old 1 1
group b new 1 1
group b old 1 1

I need to be able to pull data horizontally on another datasheet first by
type and then by group. Format looks like this:

Value1 for new Value2 for new Value1 for
old Value2 old
group name

I have no clue where to start. I have done vlookups and matches before, but
not for multiple columns. Thought of using an If statement with an and, but
can't conceptualize how it would look.

Please help!