[Doug McLean]

NIc

Power Query will allow you to take your data, and then reconfigure it just about any way you want it. It’s really nothing more than a series of pre defined steps to wash the data.

If you want the guru’s, check out guys like Mike Girvin @Excelisfun or Leila Gharani @XelPlus on YouTube. These guys will get you started. There are many others out there as well.

As Troy mentioned, I’m doing my XCON presentation in June, so make sure you register for it. I’ll be doing some of it live, so you’ll get to see it in action.