Combining the excel from a particular rows

[Sonashish]

Hello All,

I need to combine multiple excel and generating custom reports. Now probem that in each excel there is first 4 rows having some image and different information. 

During combining these excel, how Can i skip the top 4 rows from each excel?

Regards

Sonashish

[Icey · Accepted solution]

Hi @Sonashish ,

What @parry2k mentioned is like this:

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Sonashish when you combine these excel files there should be an automatic function in Power Query, you need to go into that function and add a line in the advanced editor to skip the top 4 rows. If you don't know how to do it, just copy the code in the function from the advanced editor, share it and I will make the changes.

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡