Count number values vertically, transpose the horizontally, and add numbers to the columns

[csh8428]

I am trying to take the vertical in put, count the number of times [Name] appears, transpose it horizontally, and then assign a number prefix to each column name. 

Using the attached sample dataset the number of drivers and owners for any given ID will change over time and is unknown, so the count that gets appended to the field name needs to be dynamic. The column names match my actual column names, but the values are completely made up.

I'm close, but haven't gotten quite there and am being lazy by posting here while I still work on it.

Thanks for any help!

[csh8428 · Accepted solution]

I figured it out. I sued the tile tool