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
Attaching a sample input table and desired output. I have tried the
crosstab function but the result is not correct.