Here's a simple workflow that does what you need. I did a transpose with everything as a data column, and then tiled it on names, set to equal numbers with the same number of tiles as you want rows at the end. Then cross-tab and clean up and you're done. The attached screenshot shows the cross-tab settings.