Reply
Highlighted
Occasional Visitor
Posts: 1
Registered: ‎02-17-2017

Help with Edit Query Power BI

New to power bi and looking at best steps to resolve imported excel document. Spreadsheet has column A as prod name and columns B to M are the months of the year which show the product volumes for each prod name. Column N to Y are the prices for each product name. Row1 shows the months/year..see below

 

        A                   B     C       D......  .M        N     O       P......    Y   

1      ProdName  J17  F17    M17   D17     J17  F17    M17   D17

2      Silver            5    5        10      12       $12   $12   $15    $18

3     Gold              8    6         5        10      $18   $20   $22    $24

 

 

Need to edit query of imported data to show

 

Prod Name     Date     Volume     Price

Silver               J17        5               $12

Silver               F17       5               $12

.

.

.

Gold               D17       10             $24

 

Thanks in Advance