Hi all, I’m using Power Query Editor in Excel to edit my data. I’m getting a DataFormat error when I try to expand a merged table if I merged on two columns. It doesn’t happen with any data if I merge on one column only, and always happens if I try to merge on two columns. 

All my data is in its correct format, and it doesn’t matter if I’m trying to expand a date column or not (the column I’m trying to pull through is a character column). 

Does anybody have any idea why this might be happening and how to prevent it? 

Thanks 

​Hi all, I’m using Power Query Editor in Excel to edit my data. I’m getting a DataFormat error when I try to expand a merged table if I merged on two columns. It doesn’t happen with any data if I merge on one column only, and always happens if I try to merge on two columns.  All my data is in its correct format, and it doesn’t matter if I’m trying to expand a date column or not (the column I’m trying to pull through is a character column).  Does anybody have any idea why this might be happening and how to prevent it?  Thanks   Read More

​