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 products 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'm using postgreSQL and have tried crosstab function but the results is not correct.
Table values:
Desired Ouput:
