I have a dataset in below format
I am trying to get an output in below format using R. The product names for each sales order must be split in columns. There are multiple SalesOrderNumbers and for each of the the numbers of products could be n.
I have a dataset in below format
I am trying to get an output in below format using R. The product names for each sales order must be split in columns. There are multiple SalesOrderNumbers and for each of the the numbers of products could be n.
This is a "convert data frame from long to wide format" question. There are many resources on that. The post "How to reshape data from long to wide format" will give you directions on how to do it. Here is another source https://www.datacamp.com/community/tutorials/long-wide-data-R.
Please try that, first. If you have any trouble with it, we will be glad to help you.