Forum Discussion
AVW1983
2 years agoNew Member
Adjusting my query to changes in Source file
Hello everyone, I need to extract data from a pdf table on a quarterly basis and this time Power Query reads out the heading in a Column 11 instead of Column 10. Is there any chance to get the fir...
isjoycewang
Solution Supplier
2 years agoHi AVW1983 ,
Demo file attached. Please try below steps:
1. Add a new [Index] column
2. Create new conditional columns based on [Index]
3. Remove incorrect columns and [Index]
Best Regards,
Joyce