type2

Hi, Is it possible to convert rows to columns using Power Query, as in the example below: FROM: <tbody> Code Type 123 a 123 b 123 c 456 d 456 e 789 f 789 g </tbody> TO: <tbody> Code Type1 Type2 Type3 123 a b c 456 d e 789 f g </tbody> Thanks

Need some help. In one sheet I have historical sales data. It also has sum data at the bottom, summed by month. This sum data is what I am currently feeding into a chart on another sheet manually. What I would like to happen is that the I have two drop down lists populate cells for each month...

<tbody> TYPE1 TYPE2 TOTAL1 TOTAL2 PERCENTAGE E BT 50000 50000 I NEED TO CALCULATE 3% OF SUM TOTAL1 &2 IF TYPE 1 IS "E/F/O" AND TYPE2 IS "DT"... IT SHOULD BE 5% IF TYPE1 IS "E" AND TYPE2 IS "BT" E DT 50000 50000 F DT 150000 50000 O DT 250000 50000 </tbody> Please help me to find the...

Hopefully someone can help me. This seems like it should be easy but I just cant figure it out. I have a macro that will insert a chart (XYScatterLinesNoMarkers) and plot the data series. Where I'm getting stuck is that the number and type of data are variable. Example: <tbody> Series Data...