Could you please tell us which data source are you using?
I'm assuming you wants to transpose your fields from column B-G. Correct me if I'm wrong.
Before giving any solution, its important to know the source of the data. However, you may try below approaches
• If you're using excel then you can use pivot option with "legacy connection". Same you can do using Custom SQL.
• If you're using any database like Oracle, MySQL ect then using Custom SQL you can transpose your data.
Some useful link
Let us know if this help.