Hi Aye, 

Please check your example file. The 'Expected Result' data bears no correlation to the PQ Upload or Original data.

When you resubmit your question, please specifiy which rows on the Expected result sheet are showing the errors, and what you think they should be. This will help us troubleshoot more quickly and avoid wasting time.

Thanks,

Mynda

Hi Mynda,

I have now updated with data from PQ upload or original in expected result tab.

Hope it works.

Thank you.

Regards,

Aye

Hi Aye,

Tables and Power Query cannot have dates in column headers. This layout you want is not a tabular format. This is something you should do after you Close & Load your data from Power Query, with either a PivotTable or formulas.

In the attached file I've unpivoted your data and used a PivotTable to summarise it, grouping the dates into 14 day periods. You will need to alter your starting date in your source data (just add another column with the fortnight start date) to get the grouping periods you want because at the moment they end on May 11, May 25 and so on.

Mynda