Power Query Get Transform the the in Tabular Format

[mmr1]

Hi,

I have a huge data which is converted from another source to excel required to be set in Tabular format with help power query.Headers are already available it should be same as it is, Blank columns and rows to be remove, Data in column which does not have any headers to be create a new header name in the particular that column.

Sample enclosed for reference,

Thanks for the help,

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Date	Period	Batch	Trans Ref	Chq/Db/Cr Name	Description		GRN No	Order No	Quantity	Unit			This Period	Cumulative
2				SUPER TRADING							0.00	0.00		3,445.00	3,445.00
3
4		06-Aug-2020	202008	DELACC	DO/11443		Steel Nails 1.5 Inch - Dq Holland- 1 X 120 ORDNO:DBB444063			DBB444063	100	0.00	Pkt	0.00	625.00
5	Voucher: 07A33
6		06-Aug-2020	202008	DELACC	DO/11443		Steel Nails 2 Inch - Dq Holland- 1 X 120 ORDNO:DBB444063			DBB444063	40	0.00	Pkt	0.00	300.00
7	Voucher: 07A33
8				THUNDER TECHNICAL TRDG CO LLC							0.00	0.00		(0.00)	(0.00)
9
10		09-Jul-2020	202008	DEL1673081	114510		3 WHIP CHECK 1.0 MTRS LONG		0000176767 11/07/2020	DBB441928	3	0.00	Nos	0.00	72.00
11		09-Jul-2020	202008	DEL1673081	114510		2 WHIP CHECK 0.5 MTRS LONG		0000176767 11/07/2020	DBB441928	40	0.00	Nos	0.00	600.00
12		09-Jul-2020	202008	DELACC	73304		Automatic Reversal - 3 WHIP CHECK 1.0 MTRS LONG ORDNO:DBB441928			DBB441928	-3	0.00	Nos	0.00	(72.00)
13	Voucher: 07A32
14		09-Jul-2020	202008	DELACC	73304		Automatic Reversal - 2 WHIP CHECK 0.5 MTRS LONG ORDNO:DBB441928			DBB441928	-40	0.00	Nos	0.00	(600.00)
15	Voucher: 07A32
16				ULTIMATE TRADING CO LLC							0.00	0.00		3,130.00	3,130.00
17
18		16-Aug-2020	202008	DELACC	DO-52735		ESPA PRISMA WATER PUMP 25/04 M SPAIN 1PH 2HP 1" X 1" WITH ESPA PERSSURE KIT ORDNO:DBB444546			DBB444546	2	0.00	Nos	0.00	3,130.00
19	Voucher: 07A33
20	575 - Other PandGS										0.00	0.00		7,400.00	12,242.20
21
22	57520 - Safety and Cleaning										0.00	0.00		7,400.00	12,242.20
23
24	57520021 - Safety Equipment and Signage										0.00	0.00		7,400.00	12,242.20
25									b fwd	3505					4,842.20
26
27				SAFETY EQUIP. TRADING CO.							0.00	0.00		0.00	0.00
28
29		16-Jul-2020	202008	DELACC	DT/TAS/112		Automatic Reversal - WELDER SAFETY SHOE - SIZE-40, CHALLENGER BRAND ORDNO:DBB443011			DBB443011	-1	0.00	Pr	0.00	(120.00)
30	Voucher: 07A32
31		16-Jul-2020	202008	DELACC	DT/TAS/112		Automatic Reversal - 100 COTTON FULL SLEEVE LIGHT BLUE COLOUR WELDER COVERALL TOUGH EXCEL- Size- M ORDNO:DBB443011			DBB443011	-2	0.00	Nos	0.00	(80.00)
32	Voucher: 07A32
Sheet1

 

[sandy666]

that is why I said you need to do all yourself because you removed columns which you know they are not necessary, remove rows with not necessary data, changed data/headers etc...
but it's still not a 1NF table