This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I would appreciate some help preparing some data. I have the attached input (Material Numbers and Country Codes) in two columns. I would like to group the material numbers by country, but I'm not sure how to do this. Ideally, I'd like an excel output with a separate sheet for each country with the associated list of material numbers for each country. I believe if I can get the column header to be the country code (I'm working with 23 unique codes), then I can save the output data with each country as a separate sheet using the output tool (is this correct?).
So, my ideal output is something like this (see attached dummy data for an example of what I'm working with):
*Country Codes are the headers and material numbers sold to each country are in the subsequent rows.
If you know of a better way to get to what I'm looking for, I'm all ears! Thank you!