Power Query -data transformation

[sharpy137]

I have just been upgraded to excel 2016 and have stumbled on my first attempt at using power query. I have data in an excel workbook that has a couple of rows of data sitting on its own above main data set that i would like to include in table but cannot work out solution that doesn't involve manually adding to table at the end.

Any help greatly appreciated

Network Infrastructure Application number: Application 000 Period: 26 - 31 May 2017 Contract Reference 12345 Contract Reference - Contract Type: Programme Contractor: Services Ltd Address for payment notification: address For the attention of: john doe Assessment Date Cumulative Monthly Movement Previous Cumulative Works 31-May £ 4,684,630.56 £ 154,974.47 £ 4,529,656.09 Management Fee 31-May £ 1,340,542.08 £ 51,002.81 £ 1,289,539.27 Welfare Unit fee 31-May £ 89,389.01 £ 1,899.52 £ 87,489.49 Survery's completed 31-May £ 136,236.64 £ 446.03 £ 135,790.61 Special Works 31-May £ 2,223.32 £ - £ 2,223.32 Additional Traffic Management 31-May £ 234,784.13 £ - £ 234,784.13 Total £ 6,487,805.74 £ 208,322.83 £ 6,279,482.91 £ £ VAT Gross Assessment of Value of Work Amey Works 31-May £ 154,974.47 30,994.89 185,969.36 Amey Management Fee 31-May £ 51,002.81 10,200.56 61,203.37 Welfare Unit as per new rates 31-May £ 1,899.52 Welfare Unit for May (2 gangs) 379.90 2,279.42 Survery's completed 31-May £ 446.03 89.21 535.24 Special Works 31-May £ - 0.00 0.00 Addition works 31-May £ - 0.00 0.00 Additional Traffic Management 31-May £ - 0 0.00 ref number House Number Address Date completed Actualy Install Type Length (m) Area New Boundary Box New Ferrule Cost 015/0/00530/0430 43-46 Road name 05/05/2017 Moling 5 Town b £ 759.85 015/0/00530/0510 51-59 Road name 05/05/2017 Moling 5 Town b £ 759.85 018/0/00190/0270 27-29 Road name 05/05/2017 Moling 10 Town b £ 1,118.08 018/0/00190/0310 31-33 Road name 05/05/2017 Moling 7 Town b £ 778.93 018/0/00190/0350 35 Road name 05/05/2017 Moling 10 Town b £ 1,118.08 019/0/00355/0220 22 Road name 12/05/2017 Moling 4 Town b £ 750.31 019/0/00355/0180 18 Road name 12/05/2017 Moling 4 Town b £ 750.31 019/0/03355/0181 18A Road name <tbody> </tbody>

<tbody>
</tbody>

 

[Matt Allington]

It would be easier if you could provide a sample workbook. Just load to Dropbox or equivalent, then post a link.