Cleansing Data

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....

Datasets

Accepted answers

Got it added a sort tool to meet the requirement.

Workflow:

Hope this helps : )

data cleanse.yxmd

All comments

Here is how you can do it.

Workflow:

Hope this helps : )

data cleanse.yxmd

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....

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....

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703