Creating a table arranged in a specific order

[Junkay]

Hi,

I have a source file with the following columns: Name, Department, Reward type. Reward type could be salary upgrade, promotion or conversion to FTE.

I want to create a table with the following headings to summarize the rewards based on department. The report will summarize the reward types in the following headings: Department, Promotion, Salary Uprade, Conversion to FTE. Other words, the table will have four columns. 

Thank you.

[Junkay]

Thank Ahmed. Your video was quite helpful.

[Ahmedx · Accepted solution]

to know how to do this watch my video

https://1drv.ms/v/s!AiUZ0Ws7G26RjFkyXjfW2L3r-CHl?e=oqFFPq