I am trying to output information from one of my org's pricebooks into excel for another department to review. I'm capable of getting the information with a basic select statement, but they would like it formatted differently. I'm currently using the following query:
SSELECT Product2Id, Name, CurrencyIsoCode, UnitPrice FROM PricebookEntry WHERE Pricebook2Id = '1234567890' ORDER BY Name, CurrencyIsoCode
This gets me a table that looks like this:
Product2Id NAME CURRENCYISOCODE UNITPRICE 12345 Example1 EUR 4960 12345 Example1 GBP 4000 12345 Example1 NOK 80000 12345 Example1 USD 5000 12346 Example2 EUR 1000 12346 Example2 GBP 950 12346 Example2 NOK 50000 12346 Example2 EUR 900
Instead I would like to consolidate every row that shares the same productname or associated product2id, to get an output that looks more like this:
Product2Id NAME EUR GBP NOK USD 12345 Example1 4960 4000 80000 5000 12346 Example2 1000 950 50000 900
Is there a clean way to do this using just the SOQL query editor in the data loader, or would I need something more advanced to consolidate the data in this fashion?