Text Parsing and data table

Question

Hi All,

I have a string that is parsed and extracted using text to columns, I used 20 for the number of columns.

Patterns/Characteristics:

* Column F2 will always contain " feature" 
*  There are 8 distinct categories and the text will contain the category name and then the values , the category comes first and then the next column will have the value. Example column F5-> Gender F6-> Ladies ( Value) 
* The categories and values can be in any order in the text string

Eg:

The result I am trying to get to is for each row the categories should become the column name and the values should be the rows.

End State:

nowPricegenderringStylemetalTypesmetalColorsstoneColorsstone1Shapestone1CaratRangeOver+%245%2C000LADIESBands+-+DiamondGoldWhiteWhitePrincessOver+1&text=&searchStore=Over+%245%2C001  GoldWhiteWhite&searchStore=

I am new to Alteryx , can some one point me in the right direction.

Thanks

Sample_text.yxmd

unknown · Accepted Answer

Answer attached.