Analysis relational filter

Summary:

I am trying to create an OTBI analysis as a new Oracle customer.
Certain fields have multiple values. I am wanting to create one unique row per person , where the additional values are split up in columns.

For example. Multiple phone types and numbers. But I don`t want to exclude records that don`t have a value.
This seems to be more complicated than it should be in OTBI Analysis.

I created a case statement :
case when
"Workforce Management - Person Real Time"."Person Phones"."Phone Type" = 'Home Phone'
THEN
"Workforce Management - Person Real Time"."Person Phones"."Search Phone Number"