Help with tidying data

Hello everyone,

This is just a small part of my dataset, year is only FY19 and FY20 in the whole dataset, and LoS is as is.

I want to merge by client and by year and by LoS as shown in example

If I need to clarify please tell me.

Infinite thanks in advance.


To help us help you, could you please prepare a reproducible example (reprex) illustrating your issue? Please have a look at this guide, to see how to create one: