Text Parsing and data table

[saivig68]

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:

nowPrice	gender	ringStyle	metalTypes	metalColors	stoneColors	stone1Shape	stone1CaratRange
Over+%245%2C000	LADIES	Bands+-+Diamond	Gold	White	White	Princess	Over+1&text=&searchStore=
Over+%245%2C001			Gold	White	White&searchStore=

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

Thanks

[Inactive User · Accepted solution]

Answer attached.