Cleansing Data

[Raj008]

Hi All,

I have two columns

Machine	Parts
ABC1	Coil
ABC1	Rope
ABC1	Screw
ABC1	Nut
ABC1	Bolt
ABC2	cloth
ABC2	runner
ABC2	thread

I want the output as

Machine	Parts
ABC1	Coil
	Rope
	Screw
	Nut
	Bolt
ABC2	cloth
	runner
	thread

Thanks,

Raj....

[atcodedog05]

Hi @Raj008 

Here is how you can do it.

Workflow:

Hope this helps : )

[Raj008]

Hi atcodedog05,

Thanks for you reply.

My actual requirement is 

Machine	Parts
ABC01	Screw
ABC11	Nut
ABC05	Thread
ABC03	Bolt
ABC01	Belt
ABC03	Raw materials
ABC12	Flammables
ABC05	Combustible

the above changed to

Machine	Parts
ABC01	Screw
	Belt
ABC03	Bolt
	Raw materials
ABC05	Thread
	Combustible
ABC11	Nut
ABC12	Flammables

Thanks,

Raj008....

[atcodedog05]

Hi @Raj008 

Can you repost your previous reply again. There seems to be a glitch in the community webpage.

[Raj008]

Hi,

My actual requirement is

Machine	Parts
ABC01	Screw
ABC11	Nut
ABC05	Thread
ABC03	Bolt
ABC01	Belt
ABC03	Raw materials
ABC12	Flammables
ABC05	Combustible

output as

Machine	Parts
ABC01	Screw
	Belt
ABC03	Bolt
	Raw materials
ABC05	Thread
	Combustible
ABC11	Nut
ABC12	Flammables

Thanks,

Raj008....

[atcodedog05 · Accepted solution]

Hi @Raj008 

Got it added a sort tool to meet the requirement.

Workflow:

Hope this helps : )