Power Query Get Transform the the in Tabular Format

mmr1

New Member
Joined
Aug 25, 2020
Messages
33
Office Version
  1. 365
Platform
  1. Windows
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
ABCDEFGHIJKLMNO
1DatePeriodBatchTrans RefChq/Db/Cr NameDescriptionGRN NoOrder NoQuantityUnitThis PeriodCumulative
2SUPER TRADING0.000.003,445.003,445.00
3
406-Aug-2020202008DELACCDO/11443Steel Nails 1.5 Inch - Dq Holland- 1 X 120 ORDNO:DBB444063DBB4440631000.00Pkt0.00625.00
5Voucher: 07A33
606-Aug-2020202008DELACCDO/11443Steel Nails 2 Inch - Dq Holland- 1 X 120 ORDNO:DBB444063DBB444063400.00Pkt0.00300.00
7Voucher: 07A33
8THUNDER TECHNICAL TRDG CO LLC0.000.00(0.00)(0.00)
9
1009-Jul-2020202008DEL16730811145103 WHIP CHECK 1.0 MTRS LONG0000176767 11/07/2020DBB44192830.00Nos0.0072.00
1109-Jul-2020202008DEL16730811145102 WHIP CHECK 0.5 MTRS LONG0000176767 11/07/2020DBB441928400.00Nos0.00600.00
1209-Jul-2020202008DELACC73304Automatic Reversal - 3 WHIP CHECK 1.0 MTRS LONG ORDNO:DBB441928DBB441928-30.00Nos0.00(72.00)
13Voucher: 07A32
1409-Jul-2020202008DELACC73304Automatic Reversal - 2 WHIP CHECK 0.5 MTRS LONG ORDNO:DBB441928DBB441928-400.00Nos0.00(600.00)
15Voucher: 07A32
16ULTIMATE TRADING CO LLC0.000.003,130.003,130.00
17
1816-Aug-2020202008DELACCDO-52735ESPA PRISMA WATER PUMP 25/04 M SPAIN 1PH 2HP 1" X 1" WITH ESPA PERSSURE KIT ORDNO:DBB444546DBB44454620.00Nos0.003,130.00
19Voucher: 07A33
20575 - Other PandGS0.000.007,400.0012,242.20
21
2257520 - Safety and Cleaning0.000.007,400.0012,242.20
23
2457520021 - Safety Equipment and Signage0.000.007,400.0012,242.20
25b fwd35054,842.20
26
27SAFETY EQUIP. TRADING CO.0.000.000.000.00
28
2916-Jul-2020202008DELACCDT/TAS/112Automatic Reversal - WELDER SAFETY SHOE - SIZE-40, CHALLENGER BRAND ORDNO:DBB443011DBB443011-10.00Pr0.00(120.00)
30Voucher: 07A32
3116-Jul-2020202008DELACCDT/TAS/112Automatic Reversal - 100 COTTON FULL SLEEVE LIGHT BLUE COLOUR WELDER COVERALL TOUGH EXCEL- Size- M ORDNO:DBB443011DBB443011-20.00Nos0.00(80.00)
32Voucher: 07A32
Sheet1
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
6,699
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
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,108,743
Messages
5,524,569
Members
409,587
Latest member
ChrisF1980

This Week's Hot Topics

Top