Help Creating Columns from Row Data

Question

Hello,

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!

Example Case Dummy Data.xlsx

fmvizcaino · Accepted Answer

Hi @mpielmeier ,

You can use the tile tool to create a recordID for each country.

But if you want to create a sheet for each country, we can do that dynamically with the option to take a filename from a column in output data tool.

Best,

Fernando V.