I've searched the net for the life of me, and can't seem to find what I'm looking for. Here's a basic overview of what I'm trying to accomplish:

What I have:
Before.png

What I want:
After.png


I don't know how to word what I'm looking for, but essentially I want to transpose a range of cells, but have the first cell in the column be on the same row as each record.