Forum Discussion
Get & Transform - solving all sorts of Excel issues
Some may see Get & Transform (Power Query) simply as a brilliant way of connecting to multiple data sources and loading that data into a Microsoft Power BI development environment (Excel Power...
Guy Hunkin
Microsoft
MicrosoftGreat example, Wyn! We should start posting it as a quiz before providing the solution :-) Maybe I'll start doing it soon myself.
- Thanks Guy
- Thanks for the example. I was wondering whether anyone have dealt with the Alt Enter situation when importing a large csv file? I was looking to see whether there is a way for the Get and Transform procedure to replace the end of line values prior to importing the file.
Similar to the Split Column by LineFeed you can use Transform > Replace Values and again choose LineFeed
Under advanced options choose Line Feed and then put a space in the replace with box
