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