Transforming data back to original format of rows instead of multiple columns

[timbeall20]

Below is an example of the data I'm working with.

Owner

Vendor

Product

Model

Location

Vendor2

Product2

Model2

Location2

Vendor3

Product3

Model3

Location3

Tyler

BlackRubber

Tires

10

San Francisco

MotoZone

Fairings

20

Portland

Jen

RaceCity

Detailing

30

Dubai

GlassCentral

Replacement

40

England

BreathEZ

AirIntake

50

San Francisco

I would like the data to show as follows:

Vendor	Product	Model #	Location	Owner
BlackRubber	Tires	10	San Francisco	Tyler
MotoZone	Fairings	20	Portland	Tyler
RaceCity	Detailing	30	Dubai	Jen
GlassCentral	Replacement	40	England	Jen
BreathEZ	AirIntake	50	San Francisco	Jen

The number of duplicate columns vary based on how many vendors there are to an owner. Qiu helped me transform the data to multiple columns using the owner as the unique identifier. The topic of the discussion I originally posted is Moving rows from multiple columns based on a similar column value into a single row

I need help transforming it back to rows by using the Model # as the unique identifier.

Thank you in advanced for your support.

[alexnajm]

Why do you need to transform it back if you have the original data in that format? Solved: Moving rows from multiple columns based on a simil... - Alteryx Community

[jrlindem]

@timbeall20 I've attached a solution.  This isn't the most "scalable" way to solve, but it does get you what you need for the four columns...

Hopefully you can adapt it from there!  - Jay

[jrlindem · Accepted solution]

Okay, I way over-complicated my first response 😅

This is a better version, more succinct.  Either way gets you there.  Hopefully between the two approaches you can adapt.  -Jay

[timbeall20]

Thank you, Jay! I appreciate the quick response. This helps me understand which tools I can use to transform other datasets in the future as I continue with my trainings.

[timbeall20]

For context - The first format transformation (rows to multiple columns for each owner) is the format for distribution which yields additional results & data. Reverting it back to the original format (unique row per model #) makes it much easier to report on each 'Model #', as opposed to each owner. 

[alexnajm]

Sure, but my only point was that if the input of the other question was the exact output of this question (which it is) you may not need to worry about transforming back and forth! Save some steps 😊