How to go horizontal?

This is likely a stupid question but I don’t do much excel and only just started trying to use the add-in.
I’m trying to get the list of blueprints I own to go horizontally instead of vertical, as I noted when I try to pull info like materials needed, quantity I can’t get neat columns, so am hoping transposing it lists better. Is that doable or should I be trying to do this in some other way? I’m trying to create a master sheet basically that will show all my BP’s, what they require to be built, how much it’ll cost and how much I can make/lose by selling the end product.

Surround with a TRANSPOSE() function.

I am curious if there is a single character like the #, or @?