Data Organisation Help

[dbrown94]

Hi there, 

I have a data set (current- on the left side of my screenshot)  and required- the right hand side. Are there any beginner friendly ways I might achieve the 'required' layout?

[binu_acs]

@dbrown94 one way of doing this