Forum Discussion
MicrosoftQuickly transform some data for analysis using Copilot in Excel
Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. We have transitioned from daily to weekly and we are posting on the Excel blog (https://aka.ms/xlblog).
This week's example shows how to quickly transform this table:
Table of partner meetings with columns for Meeting name, Attendee ID, Join Time and Leave Time
Into this:
Table of partner meetings with columns for Meeting name, Attendee Name, Attendee ID, Join Time, Leave Time and meeting duration.
To read how to use Copilot to do this, click here: Quickly transform some data for analysis using Copilot in Excel.
Microsoft Excel Team
2 Replies
Ensure you have access to Microsoft Copilot, as it's available in certain versions of Microsoft 365. To start using Copilot, you can usually find it in the Ribbon or by typing your request directly into a cell.
If the initial transformation doesn’t meet your expectations, you can refine your request. For example, “Can you make that chart a pie chart instead?”
