Expand Excel Spreadsheet out based on a column

Question

I have a spreadsheet like this:

Name        Online         Retail         Trade
Widget 1    $352           $532           $235

I need to get it looking like this

Price Level       Price      Name
Online            $352       Widget 1
Retail            $532       Widget 1
Trade             $235       Widget 1

Is that possible with Excel?

Answer 1

Yes. For how to flatten your data please see and then re-order and rename your columns to suit.