I have a data table where I have a list of products against a particular invoice number. I need to reorganize the table such that the products are listed in columns along the invoice number instead of rows. Having it listed in rows results in duplication of the invoice number and is creating problems with analysis. I have attached a screenshot of the data table that I am referring to.
Would appreciate any help regarding the matter.
Note: Attached image is from a sample data. The actual database is too big for it to be done manually.
Bookmarks