Dividing Columns based on another column

Hello Alteryx Community,

I am new in to Alteryx but have a good background of SQL.

I have an excel file containing a column which has SKU level of different components and in next column I have the component name.

I need to create different columns based on SKU level (like L1 - L6) each having populated by there respective component name.

Below have attached a screenshot of input and output data.

I would really appreciate it if this could be done in a easy and simple to implement way.

Thanks in Advance for the help.

Screenshot (100).png

Workflow

Accepted answers

One way of doing this.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution

Thanks.

One way of doing this.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution

Thanks.

Thanks for the solution. it's working with my format. Thanks for this simple and easy to apply solution.

Thanks for solution. The solution is working for my format. Thanks for this simple and easy to apply solution.

@mrai02 Another way of doing this is to retain the original order of the records