How to display multiple values in seperate columns

We're creating a report with employee data and part of the report are e.g. e-mailaddresses. When e-mail type is part of the report, the result is multiple lines, but we want to have e.g. work-email in a column and private or home email in a seperate column.

Same for addresses.

The formula for a column holds the selected value ("Person Email Addresses"."Email Address") but how can I filter this for e-mail type?

Can the same solution be used for address etc.?

Thanks in advance