Cleaning Data - Making Data ready for Power BI

[agd50]

I have some data that looks like this (sorry I can't show more) - It has some text for about 5 rows above the table and I have to combine data together from different files (20 or more) and on top of that the data is across diffferent sheets.

Need to combine into one sheet - I'm using power query and combine to try and speed this up - but I was wondering if anyone knew a quicker/better approach?

Regards,
Andrew 

[amitchandak · Accepted solution]

@agd50 , Not very clear,

you can use merge or append to merge data

 : https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Clean and trim to clean data:

Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4

Also check this powerful function addfuzzyclustercolumn

https://learn.microsoft.com/en-us/powerquery-m/table-addfuzzyclustercolumn