Saved search for items on sales orders exploding out quantity

Hello,

I'm trying to get a transaction line report using a saved search that explodes each line by the quantity on that line.  For example, in NetSuite, the standard transaction saved search looks like this:

Item Name | QTY | Price  |  Amount
Item ABCD   | 3  |  $250 |   $750


I want it to look like this:
Item  |   Price  
Item A        $250     
Item A        $250
Item A $250

Basically, I want to unpivot the data as it is stored in NetSuite and list it in tabular format, with one line for each quantity of item.

Does anyone know how I can do this with a saved search?  If not, we also have ODBC, so that may be an option as well.