Transform one table column into two columns

[Zaibass81]

Hello, 

Looking for some help:

The goal is re-shape data based on the ranking. All parts has rank 1 & 2 Only.

The desired outcome to transform the data into vertical table where rank2 items appearing on the left hand side.

[serpiva64 · Accepted solution]

Hi,

you can try the transformation listed in the attached file

and you obtain this

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !

[Zaibass81]

Thank you very much! Excellent solution. As I had to create two different tables, one with filter rank 1 and the other with filter rank 2, I created a unique attribute and joined the two tables. Your solution, however, is more effective.