Power Query Get Transform the the in Tabular Format

mmr1

Board Regular
Joined
Aug 25, 2020
Messages
80
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
 
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
 
Upvote 0

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Forum statistics

Threads
1,213,479
Messages
6,113,894
Members
448,530
Latest member
yatong2008

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top