Forum Discussion
Column from Examples Option is not available in Excel 'Add Column'
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.