changing flat data to data grid

[rrrggg20]

Hello everyone, I have a data format looking like this

Project, Project Phase, CostDate, Grouping, Cost, year

p1, Ph1, 1/1/2020, g1, 1000, 2020

p1 ,Ph2, 1/1/2020, g1, 2000, 2020

p1, Ph2, 2/1/2020, g1,3000, 2021

p1, Ph2, 3/1/2020, g2, 4000, 2021

what I am trying to get out is a grid like this

Project	Group	Phase	2020	2021
P1	G1	Ph1	1000
P1	G1	Ph2	2000	3000
P1	G2	Ph3		4000

I can get it to put the cost in all the phases, but not able to only put it in the (X/X)/Y coordinate that it belongs

X = Group

other X = Phase

Y = the costs occurred in the given months of the year.

Not looking for a completed solution, but thoughts around how this can easily be done

Thanks

[QFabian · Accepted solution]

H i@rrrggg20, i recreate your data and made this little qvw, please check it.

it is just a pivot table suming Cost and the dimensions you need

The only thing i cant understand is if you want to create Ph3