Forum Discussion

AVW1983's avatar
AVW1983
New Member
2 years ago
Solved

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's avatar
    2 years ago

    Hi 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