Excel data transpose for adding slicers

Hi,
I have data set of employee skill matrix in format "Sheet A", and i want to convert this data into format "Sheet B"
i have made this sample manually by copy, pasting the data, let me know if there are any formulas to do

please help

Formulas
Name

Formula:

Please Login or Register  to view this content.

Category

Formula:

Please Login or Register  to view this content.

Sub Category

Formula:

Please Login or Register  to view this content.

Rating

Formula:

Please Login or Register  to view this content.

hi Czeslaw, awesome it is working, thank you

1 Project Data Analysis (Financial Utilisation, WIP)
2 Management Information System
3 Project Scheduling
4 Project Monitoring
5 Earned Value Management
6 Change Management
7 Cost Control
8 Project Closure
9 Risk Management
10 Project Budgeting
11 Estimate at Completion
12 Document Control

understood, thank you