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...
Hi Anonymous ,
If I understand your question correctly that you want to do some data format changes in query editor when you get data from SharePoint Online?
If so, please share your desired format so that I could understand your desired output better and help further on it.
Best Regards，
Cherry
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