How to use any regex method to separate values into column and its row

[mahnoor1279]

Hello everyone  i'm new to qliksense and i was assigned to a taske to separate value the below value into column and its respective value 

for example :

ResultSet : Electronic_Email_statement :null| isIsaveActive :no| AccountCode :04123| AccountTitle :xyz     | AccountSNo :33221155        | AccountCat :null| mobileNo : 9123456789 

this should be like this 

Electronic_Email_statement        isIsaveActive          AccountCode    AccountTitle     AccountSNo      mobileNo 

null                                                          no                              04123xyz                             33221155        9123456789