Notifications
Clear all
Power Query
6
Posts
3
Users
0
Reactions
90
Views
Topic starter
Respected Sir/Madam
I need your suggestion on power query related issue. Every month I have to combine data of 30 workbooks having two different sheets in each workbook, I promote first row as header ,but I still see those headers from 2nd,3rd ... Files populated into combined data set.
Kindly help me how to remove those repeated headers
Thanks & Regards,
Venkata Arjun.D
Posted : 10/07/2022 9:35 pm
Why not just filter them out?
Posted : 10/07/2022 10:50 pm
Topic starter
Sir kindly share the procedure to delete the repeated headers
Posted : 11/07/2022 2:47 pm
Hi Venkata,
Please supply some sample data showing the way the data and headers are mixed in your table following import by PQ.
Without this it's hard to give you anything other than a suggestion or general idea what to do.
Regards
Phil
Posted : 11/07/2022 6:32 pm
Topic starter
Respected Sir
Please share email id so that I can detailed information
Posted : 15/07/2022 8:39 pm
emails are not the way. It does not allow for all in the forum to understand the issue. Attach a file to this forum. Click on the link below to attach a file. This is standard for excel forums. Emails are not part of the forum standard procedure as that is sharing private information in public. We don't do that.
Posted : 16/07/2022 12:10 am
