Below is an example of the data I'm working with.
| 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 |
I would like the data to show as follows:
| 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 |
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.
