need to split some loaded rows into 2 rows

[twills12]

I have some rows I am loading that will need to be split into 2 rows.  Unable to get my head around how to accomplish.

Sample data...

Category             Date                   Description

Access                  10/1/2020        Incomplete credentials

Access, Data      10/15/2020      Credentials, missing required items

The first record I would reflect with a count of '1' and display the row. 

Access      10/1/2020      Incomplete credentials      1.0

The second record I would like to reflect a count of '.5' for 'Access' and '.5' for 'Data' and display 2 rows, breaking each out into something like this...

Access      10/15/2020      Credentials, missing required items     0.5

Data     10/15/2020      Credentials, missing required items      0.5

Any suggestions on how this could be done?

[dplr-rn · Accepted solution]

Use subfield function.

in your script use this line

subfield(Category,',') as Category

refer this 

https://community.qlik.com/t5/QlikView-Documents/The-Secret-Life-of-SubField/ta-p/1479876

[twills12]

Absolutely beautiful!  I knew about subfield but didn't think it would be the solution here.  Thanks!