Forum Discussion
Combining the excel from a particular rows
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
2 Replies
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.⚡
