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....
Solved! Go to Solution.
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 @Raj008
Can you repost your previous reply again. There seems to be a glitch in the community webpage.
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....