Hi All,
The title sounds more complex than (I think) the problem is. I have a dataset with a column "Type" that contains the type of test, the column "NumericResult" has the value for both these tests. The column "Part id" has duplicates because both tests were preformed on each part.
Original dataset image:
https://i.ibb.co/fYPpZ4t/1-1.jpg
I want to create custom columns for "Laser Power" and "Porosity" but this leaves me with empty values, I would like to filter those out and simultaneously group the dataset by "Part id" so I can get these values on the same row. I have tried transforming the dataset in various ways but cannot find a resolution. I'm still learning so perhaps someone can let me know whether this is actually feasible and if so point me in the right direction?
Desired result image:
https://i.ibb.co/xj9LXzS/2-2.jpg
Sample datasets
Thanks in advance and I apologize if there's already a topic for this, I couldn't find anything similar
