Unstack Staff Leave Details

[SimiSA]

Hi All

Please help me, attached file is an export from our system, I need to unstack/convert to a workable table in excel so I can analyze.

Any solution welcome (Formulas, PowerQuery or other)

Thanks in Advance
Simi

 

[vletm]

SimiSA
What would be layout of table, that You could analyze it?
Could You upload a sample of it?

 

[SimiSA]

Hi Vletm

thanks for the reply, I will upload on monday when I have connection to our server at work.

 

[GraH - Guido]

Like this? (Used PQ)

 

[SimiSA]

Yes, Incredible man, Thank you.

Please share the steps.

 

[SimiSA]

I can see PQ step names but unable to open and view actual step details

 

[GraH - Guido]

Hi, the source step needs to be changed to the path where you have saved the file.
= Excel.Workbook(File.Contents("K:\uploads\leave_Summary1 Temoso.xlsx"), null, true) -> I have used this to avoid PQ turns the data range into a table. Alternative is using a named range. See new upload.

 

[SimiSA]

Hi GraH - Guido

Just one my new report and your solution work 100%

Thank a lot.