Help with arranging data

[EricaMN]

Hi there ,

I have a dataset that looks like the below 

Programme	Level	Year	Outcome	Total Attrition %	Headcount
Sport	Level 4	2020/1	Fail	97%	65
Sport	Level 4	2020/1	Transfer		7
sport	Level 4	2020/1	Withdrawn	3%	2
Sport	Level 4	2020/1	Total Attrition	13%	67
Sport	Level 4	2021/2	Fail	80%	25
Sport	Level 4	2021/2	Transfer		3
Sport	Level 4	2021/2	Withdrawn	20%	8
Sport	Level 4	2021/2	Total Attrition	12%	33

I have hundreds of rows of data for various programmes and I tried filtering on the year and creating the table separately then appending the two columns (labelling them attrition % 2020/1, Headcount 2020/1 as below). This worked where I had three different programmes, but now that I am attempting it with several hundred, it is not showing the correct figures for the appended year. Any advice is appreciated.

This is the end table I'm aiming for. 

Programme	Level	Outcome	Total Attrition % 2020/1	Headcount 2020/1	Total Attrition % 2021/2	Headcount 2021/2
Sport	Level 4	Fail	97%	65	80%	25
Sport	Level 4	Transfer		7		3
sport	Level 4	Withdrawn	3%	2	20%	8
Sport	Level 4	Total Attrition	13%	67	12%	33

[pdave87]

@EricaMN can I take a look at source / input files with your workflow?

[Qiu · Accepted solution]

Hope this is what you need.

[EricaMN]

Thank you very much @Qiu! it has worked. I hadn't thought to change my fields to strings so I could concatenate!  much appreciated! 

[EricaMN]

Thanks for replying, I was given the solution. 

Thanks!

[Qiu]

@EricaMN 
Glad to help and thank you for the accept mark!