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.

ShankerV

Hi @kafka_u21 

Further if you need to have the results like below, you can use one more Text to columns tool.

Step 1: Input

Step 2:

Step 3:

Step 4:

Many thanks

Shanker V