8 Replies Latest reply on Sep 4, 2018 10:52 AM by Joshua Milligan

    Convert rows into columns

    Carlos Salinas

      Hi,

       

      I have a table that has the items of an order with their status. (The Order_number may be repited)

      I need to convert the table into a Pivot, beacause I want to count the numbre of items in each status and then join the result with another table using the order_number as the link field.

       

      Here is the example of the table and the expected result. Can you help me do it in tableau Prep.

       

      Thanks!

       

      Hi, I attached the data in excel with the wanted response. thanks for your help. Regards.