Forum Discussion

mnarsimhadri's avatar
mnarsimhadri
Copper Contributor
May 22, 2023

Column from Examples Option is not available in Excel 'Add Column'

Hi There,

 

I do not find Columns from Examples option in Excel Power Query Editor. May I know the reason, I am using Excel on MacBook.

 

Please help to find a solution.

 

 

Thanks,

Narsimhadri M

 

BI & Data Analysis
excel
Excel on Mac

2 Replies

Sort By
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    May 22, 2023

    mnarsimhadri 

    The "Columns from Examples" option in Excel Power Query Editor is currently only available in the Windows version of Excel and is not available in the Mac version, as far as my knowledge.

    The "Columns from Examples" feature allows you to specify the transformation steps in Power Query by providing examples of the desired output. It is a powerful tool for data transformation and cleansing tasks.

    As an alternative, you can try using formulas or custom functions in the Power Query Editor to achieve similar results. You can also consider using a Windows computer or virtual machine to access the “Column from Examples” feature in Excel.

    Microsoft regularly updates their software, so it's possible that this feature may be added to the Mac version in the future. I recommend checking for updates or consulting Microsoft's official documentation or support channels for the latest information on feature availability in Excel for Mac.

Resources