Quickly 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