Text to Columns & Rows from Single Cell

[kafka_u21]

I am new to Alteryx, hence the query:

I have data formatted in an excel in a single column, i need to break it into multiple rows & columns with headers. how to go about it?

Single data cell contains this continuous data like : "ID:123,name:smith,city: chicago,state;IL,Country:US;ID:234,anem:john,city:LA,State:california"....

Basically i want it to be displayed in table structure with table headers of ID, Name, City, State & Country and data in rows.

[kafka_u21]

works perfectly. Thanks so much,

[kafka_u21]

Thanks flying008, but the input actually is in a single column and single row. I used the solution provided earlier and it worked for me. but thanks for this, pretty sure will be useful for me as i continue learning more about alteryx.