Moving rows from multiple columns based on a similar column value into a single row

Question

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

VendorProductModel #LocationOwnerBlackRubberTires10San FranciscoTylerMotoZoneFairings20PortlandTylerRaceCityDetailing30DubaiJen

GlassCentralReplacement40EnglandJenBreathEZAirIntake50San FranciscoJen

I would like the data to show as follows:

OwnerVendorProductModelLocationVendor2Product2Model2Location2Vendor3Product3Model3Location3TylerBlackRubberTires10San FranciscoMotoZoneFairings20Portland    JenRaceCityDetailing30DubaiGlassCentralReplacement40EnglandBreathEZAirIntake50San Francisco

The variation number of vendors to owners vary with the data I'm using.

I was able to do it for one of the columns using the Cross tab tool and then Text to Columns, but the list I'm working with is too large to have any one of the columns as the header when using the Cross tab tool.

Thank you in advanced for any support.

Qiu · Accepted Answer

@timbeall20 
It will be a typical use case for Combination and Cross Tab.

timbeall20 · Accepted Answer

Thank you Qiu, this worked exactly how I was hoping to. I appreciate the quick response.