How to create a new Pivot table from existing table by applying filters in PowerBI

I am a total newbie for PowerBI. Need help on achieving the below task. I have a table as in the link: Table1

I want to create a separate table(pivot table with name Output) with column names as values from col2 of Table1 and rows from values in col3 by filtering col1 with vales containing 'real' as a substring.

The expected table (Output)from Tabe1 would be: Output