Power query question

[msavides]

I have a project for 1500 timesheets 2 times a month. 

we download a spreadsheet from our payroll company that contains all 1500 employees time entries and shift notes in a single xml file. 

what I need to do is run a query to pull just a single employees time entries and shift note into a new excel file.  I need to do this for all 1500 employees. 

so source file is a master timesheet excel file and I need 1500 individual excel spreadsheets that just show each employee time entires and shift notes. 

is this possible with power query.  I have been watching a lot of power query videos and i cannot find a single one that says it is possible. 

Thank you in advance for any help you can provide

[Anonymous]

In the formula bar, type:

= let Rows=Table.RowCount(NameOfPriorStep) in Table.Split(PriorStepName, Rows)

--Nate

[Anonymous]

It is possible but not efficient or suitable. I wouldn't recommend using Power Query to achieve this. I would try to do it in Python (don't worry you don't need to be an expert in coding to do it, there are many libraries, trainings and pre-built templates do to what you want to do) or through Power Automate.