Forum Discussion
Manipulating data from an excel spreadsheet
Hi all I have a whole bunch of Excel files that are stored on a SharePoint Online Teamsite. I can access these files in PowerBI and expand them out but I'm having trouble manipulating them afterw...
Yes that sounds right. The final result would look like the attached. Except in PowerBI, not Excel if that makes sense...
So a table with the headings:
Attendee WOPID, Attendee name, Department, Date Registered, Attended, Course Name, Course Date, Course Time
FInal format that I'd like