Moving Certain Column Values to Bottom Row

[see-seo]

Hi Community,

I desperately need help on knowing how to convert from 'Image 1' to 'Image 2'

I basically want the Pizza, Taco, Coke, and Fries sorted by Code. But the Code will repeat itself until all the values for the foodies are filled in.

Thank you for your effort in advance.

I am attaching an example model.

12

[john_miller9]

Ok, let's try that again.  

[see-seo]

Hi John,

Unfortunately, the import results in failure still.

This might be a stretch, but could you take screen shots of the configurations for each tools and post?

If this works, it would definitely help to end today on a high note!

[john_miller9]

@see-seo See the configuration in the image below.  I'm also attaching the workflow in unpackaged form, in the event that the packaging was causing the import error.

[see-seo]

Hi John,

Thank you so much for the screenshots and posting the unpackaged form of the model!

I think the packaging was the issue, but I see the model now.

However after looking at the model, I realized that I might have oversimplified my question.

So here are similar looking data with different number sets.

Could you help me on making the first table to transform into the second table?

Thank you so much again!

[john_miller9 · Accepted solution]

Okay - that's actually easier but follows the same process.

[see-seo]

Hi John,

I really appreciate all of your time and effort spent on helping me out.

I was able to integrate yours to my real model and have to do some minor tweakings now.

Thank you for being so helpful and being patient with a beginner!