Convert one Cell to columns

[Sean_RJ]

Good Day,

We have a column in a report that looks like the following:

Part Of__zZz__DIVISION__zZz__16,Part Of__zZz__SUBDIVISION__zZz__9E,Part Of__zZz__GROUP__zZz__119,Part Of__zZz__SUBGROUP__zZz__00,Part Of__zZz__DEPT__zZz__X0T00,Part Of__zZz__BUSUNIT__zZz__100,Part Of__zZz__OU__zZz__31,Part Of__zZz__APPLIMIT__zZz__00,Part

We would like to Perform the following on the above column:

Division	SubDivision	Group	Subgroup	Dept	Busunit	OU	Applimit	Etc..	etc..
16	9E	119	00	X0T00	100	31	00	etc	etc

This is one column and would like to keep the rest of the column's as is.

I was thinking of a transpose then deleting left right but was not sure on what tools to use.  Thank you for your help!

[PhilipMannering · Accepted solution]

Something like this should do the trick. If you have multiple rows, then add a Record ID and group by the Record ID in the Crosstab Tool,

[FinnCharlton]

Hi @Sean_RJ , here's how I would approach it:

Hope it helps!

[binuacs]

@Sean_RJ Another method to keep the same order of the columns

[Sean_RJ]

Thank you everyone!