Forum Discussion

bigdee008's avatar
bigdee008
Frequent Visitor
7 years ago
Solved

Unpivot Multiple Columns - Desktop

**total noob alert*    Is there a to unpivot multiple data in PBI desktop?    I have datasource = Excel which is has an unusable data structure. Table headers are shown transposed below: Im looki...
Need Help
bigdee008's avatar
bigdee008
Frequent Visitor
7 years ago

Thanks for the quick Reply Greg.

 

The file in its current state has 65 Columns.

 

In a desired future state, its should have only about 27 Columns.

 

I transposed the the data in my post to make it more meaningful because the table got stripped out while it got posted.

 

 

The columes are hardly reconizable 

Current HeadersAD_TYPEAD_WEEKAD_YEARPROGRAM_TYPEPROMO_START_DTPROMO_END_DTVendorSP_RETAIL_PRICEU_PUR_ORG_NUMU_PUR_ORG_NMU_DIST_CHANNEL_NUMU_DIST_CHANNEL_NMB00_QTYB01_QTYB01_TRANSMIT_DTB01_DELIVERY_DTB01_PICK_DTB01_PREQ_CREATE_DTB01_SOURCEB01_LDGGROUP_VSRB02_QTYB02_TRANSMIT_DTB02_DELIVERY_DTB02_PICK_DTB02_PREQ_CREATE_DTB03_QTYB03_TRANSMIT_DTB03_DELIVERY_DTB03_PICK_DTB03_PREQ_CREATE_DTB04_QTYB04_TRANSMIT_DTB04_DELIVERY_DTB04_PICK_DTB04_PREQ_CREATE_DTB05_QTYB05_TRANSMIT_DTB05_DELIVERY_DTB05_PICK_DTB05_PREQ_CREATE_DTB06_QTYB06_TRANSMIT_DTB06_DELIVERY_DTB06_PICK_DTB06_PREQ_CREATE_DTB07_QTYB07_TRANSMIT_DTB07_DELIVERY_DTB07_PICK_DTB07_PREQ_CREATE_DTB08_QTYB08_TRANSMIT_DTB08_DELIVERY_DTB08_PICK_DTB08_PREQ_CREATE_DT
Desired New HeaderAD_TYPEAD_WEEKAD_YEARPROGRAM_TYPEPROMO_START_DTPROMO_END_DTVendorSP_RETAIL_PRICEU_PUR_ORG_NUMU_PUR_ORG_NMU_DIST_CHANNEL_NUMU_DIST_CHANNEL_NMQTYTRANSMIT_DTDELIVERY_DTPICK_DTPREQ_CREATE_DTSOURCELDGGROUP_VSR                                    

 

 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

OK, well then this really comes down to how you want to combine the columns that you want to combine. So, for example, let's say you have columns A, B and C and you want a single column for them. What are the "rules"?

 

Because let's say you just want the sum of those in a column, you could create a new column:

 

D := [A] + [B] + [C]

 

Then you would delete columns A, B and C in the next step.