Differences between Excel and Get & Transform

- Before we fall completely in love with Get & Transform,…we have to go over a few points…because some tasks are still easier to do in native Excel,…some Get & Transform features aren't intuitive,…and error messages aren't always helpful.…This requires us to be very strategic…in how we approach certain tasks.…So let's look at a few things.…First of all, we have this list of data…of bakers and location.…The locations, Nebraska, New Jersey, Arizona,…are bold, and that's the only cue we have.…

So if we wanted to separate these,…the states and the names,…and go into Get & Transform,…let's check out what happens.…Select the data set.…From Table.…Ah. Now the data looks like one big stack…with no cue as to how to separate what from what.…If that was the only cue we had,…we would have to correct it in native Excel.…The next caution:…We cannot operate at the cell level.…

Let's say Aurelia Ball,…her name is really Aurelia Bell.…We can't make that change here.…So let's close and load this to the workbook.…We have to make that change at the source.…