Converting Query Table into Summary

[gplhl]

Hi All,

I am trying to convert data from a query into a print out. The table shows a list of skills along the top and the status for the employee in the table. I want to create a summarised printable sheet that converts that data to show:

Skill (e.g. IOSH Working Safely)
Status (e.g. Expiring Soon, Out of Date, Required, Not Required)
Name (I have removed surnames for screenshot, all are unique with an employee ID)

I cannot see how I can achieve this from the data in this format, I would be filtering out all but Required, Out of Date and Expiring Soon?

Thanks.

 

[gplhl]

Thought I would post an update, I have managed to get the result I wanted by writing a macro with iterations, "for i to", to repeatedly convert data to a list in another sheet. I was really hoping to avoid as our network regularly messes up workbooks with VBA modules in them. Once its in a list, its easy to then create a pivot table from that and users can then use slicers to filter. If anyone else has an idea how I can achieve this list without the use of a macro, I would be really interested.

 

[RoryA]

It appears that you just need to unpivot the Skill columns in your original picture.

 

[gplhl]

The original data is not a pivot table. How would I un-pivot that data?

It’s a query to a simple spreadsheet, not using a table, using a named range. Whereby managers enter a date training has been completed. Or indicate not required. My lookup sheet converts dates and restricted entries to its status.

 

[RoryA]

In the query editor, select all the non-skill columns, then right-click one and choose Unpivot other columns.