Have you considered the Excel function "Transpose"?
not really sure works with my project.