I have a scenario where I have to pivot a list of rows to columns dynamically .For a particular order_number there might be several products. I want all those products to be in a separate column, along with its product_id (that too in columns), but we cannot predict how many products will there for a particular order_number.
Attaching a sample input table and desired output. I have tried the crosstab function but the result is not correct.
Table values:
Desired Ouput:
