Below is an example of the data I'm working with. OwnerVendorProductModelLocationVendor2Product2Model2Location2Vendor3Product3Model3Location3TylerBlackRubberTires10San FranciscoMotoZoneFairings20Portland JenRaceCityDetailing30DubaiGlassCentralReplacement40EnglandBreathEZAirIntake50San Francisco I would like the data to show as follows: VendorProductModel #LocationOwnerBlackRubberTires10San FranciscoTylerMotoZoneFairings20PortlandTylerRaceCityDetailing30DubaiJen GlassCentralReplacement40EnglandJenBreathEZAirIntake50San FranciscoJen 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.

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

San Francisco

MotoZone

Fairings

Portland

Jen

RaceCity

Detailing

Dubai

GlassCentral

Replacement

England

BreathEZ

AirIntake

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.

Datasets

Transformation

Accepted answers

jrlindem

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

Transforming Data Back v2.yxmd

All comments

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

Transforming Data Back.yxmd

jrlindem

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

Transforming Data Back v2.yxmd

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 😊

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703