How can I convert rows into columns.
Needed Output:
OrderId -> Product1 -> QuantityOfProduct1 -> ... ProductN -> QuantityOfProductN -> totalAmount -> Date
Please help me to achieve this. sorry for improper questioning. Thanks in advance.
How can I convert rows into columns.
Needed Output:
OrderId -> Product1 -> QuantityOfProduct1 -> ... ProductN -> QuantityOfProductN -> totalAmount -> Date
Please help me to achieve this. sorry for improper questioning. Thanks in advance.