Move column headers to row

Hello,
I have a sales spreadsheet with one row per account and each row shows the acount's products, quantity, price and sales going across the top of the spreadhseet as column headers (in groups of 3 columns). I need to move those columns into rows so I can pivot off of them. Is there a formula I can use to do this? Attached is a sample of what I currently have and what I would like it to look like. Thank you in advance!
Tina

Perhaps something like this?


regards

Thank you for the quick reply! Do you mind walking me through how the formula works. I'm not familiar with the functions you used. Thx!