Forum Discussion
mnarsimhadri
May 22, 2023Copper Contributor
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
2 Replies
Sort By
Excel for Mac has quite limited version of Power Query.
- NikolinoDEGold Contributor
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.