Power Query Dynamic Merge Columns

Hi -

In the process of learning Power Query and M. I'm loading PDF's from our enterprise system and although the PDF layout is exactly the same for each data pull, sometimes the data comes over into Power Query different. Sometimes the PDF comes over in 13 columns, while other times it comes in 16 columns. I'm merging all the columns of the PDF into 1 column, but my code doesn't work if the source PDF has 16 columns. I've searched for several hours now and can't really find a good answer. Seems like what I've come across involves several steps and I can't believe that this is the easiest way. Below is the m code that I have for the 13 column file. I'm really looking for a line of code that says "merge all columns in the source PDF into 1".

Anybody come across this and found a quick solution?

Please Login or Register  to view this content.

Thanks,
GRC

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Hi,

Would it be possible to upload the 2 instances of pdf files with the 13 columns and the 16 columns?

if the data is confidential please change the info to something else and give us a expected outcome to compare and alter the m language code sniped

thanks

I'm not sure what the attached file does to show the issue, but looking at the Mcode in the Original Post, for the line

#"Merged Columns"

it appears that you are only merging 13 columns. Why not change your line of Mcode to

Merge your data into a New Column and add an if-then statement for 13 versus 16 columns. You can then delete the extraneous columns