getandtransform

  1. R

    Line break causing issues combining .csv file with comma delimiter

    Hey All, Ran into a problem this week and I'm curious if anyone knows why it occurs, plus if there's a simpler way to fix it than what I had in mind. I work in marketing and use excel power query and power pivots to summarise our data (they're amazing for this). I'll frequently use power...
    • Rosie_222
    • Thread
    • #excel powerquery combinefiles csv files getandtransform
    • Replies: 1
    • Forum: Power Tools
  2. G

    Summarising data help (with pictures)

    I'm stuck on the best way to summarize date. I have 30+ Techs, they each have their own workbook set out as per, "User Workbook Example" Each tech may do a different job each day.. they may do the same, however in there workbook the jobs are laid out as tabs at the bottom. My Example here is...
  3. O

    M Language (Excel 2016 Get and Transfom) Add several columns with totals

    The data source has columns 1 to 25. I need to insert several Totals columns each adding the values of 5 columns (Total1 = Col1+Col6+Col11+Col16+Col21; Total2 = Col2+Col7+Col12+Col17+Col22; .........;Total5 = Col5+Col10+Col15+Col20+Col25) Other than manually adding five lines of...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top