Forum Discussion

antung213's avatar
antung213
New Member
1 year ago

Incomplete data input due to merged cells with raw files

Dear friends,

I have data source (I can't change) containing tables as Excel with 2 first rows are merged into group column and the data set is below those 2 lines. My problem is that seems like Power Query might interpret the first two merged rows as headers or as a single block of data, leaving the rest unrecognized.

 

The issue seems to be happened with only raw file where no changes has been made. If I edit anything or just even re-save the file, the issue is gone. It's quite confusing to me on how to deal with this. I have like 20 files so open and save is still doable but I want a way to work around.

 

If anyone experience the same issue, please help me.

 

Thanks and regards,

4 Replies

    • antung213's avatar
      antung213
      New Member

      Hi, due to the confidentiality, I cannot share the file. However, I will put 2 screen capture as below:

      1. Raw file:

      2. Still the raw file but being opened and saved (change nothing inside)

      Please help! Thank you

    • antung213's avatar
      antung213
      New Member

      Sorry, the link is private so that I cannot see it.