locked
PowerQuery 2016 Question RRS feed

  • Question

  • In the old PowerQuery Tools, there were data cleansing tools/Quality tools. I don't see this in Excel 2016?

    Does anyone know where these went. Example, I was able to take rows and move them to columns.


    • Edited by ResidentX10 Saturday, June 11, 2016 5:35 PM
    Saturday, June 11, 2016 5:34 PM

All replies

  • Hi ResidentX10,

    Which version of old Power Query and Excel did you use?

    I tested in Excel 2010 and Excel 2016.

    But I didn't find the feature in Excel 2010, did you know the name about the feature?

    Which kind of data source did you use to connect?

    Please provide more information about this problem and I'm glad to help you.


    Regards,

    Emi Zhang
    TechNet Community Support


    Please mark the reply as an answer if you find it is helpful.

    If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Monday, June 13, 2016 9:18 AM
  • Excel 2016
    Monday, June 13, 2016 11:14 AM