I have a sample data which I wanted to create a column but unable to do it it alteryx.

[XXX_Rosy_XXX]

I have a sample data which I wanted to create a column but unable to do it it alteryx. Hope someone can help.

I tried transpose however it doesn't help. 

Attached is the sample data. Below are the columns that I want.

[PangHC]

i did it. 

you need to
1. split the FacilityID

2. generate the header to be used in crosstab (or pivot)
3. use two crosstab. (because it actually combine of 2 different pivot)
4. join both table.

but I suspect this is a tutorial question, so i will not post any solution here.