Excel 2016 Power Query issue

%3CLINGO-SUB%20id%3D%22lingo-sub-2225572%22%20slang%3D%22en-US%22%3EExcel%202016%20Power%20Query%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2225572%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20used%20Power%20query%20to%20combine%204%20tabs%20into%20one%20tab.%20I%20made%20sure%20all%20the%20columns%20are%20same.%20But%20when%20I%20combine%20the%20tabs%2C%20power%20query%20is%20giving%20an%20extra%20column.%20It%20is%20repeating%20the%20same%20column%20twice.%20What%20can%20be%20the%20reason%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2225572%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2225661%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%202016%20Power%20Query%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2225661%22%20slang%3D%22en-US%22%3EIt%20is%20not%20technically%20possible%20to%20answer%20this%20question%20without%20more%20information.%20%22extra%20column%22%20and%20%22repeating%20the%20same%20column%20twice%22%20have%20absolutely%20no%20meaning%20without%20context.%20Where%20is%20the%20%22extra%20column%22%20and%20what%20is%20%22the%20same%20column%20twice%22%20that%20is%20repeated.%20To%20determine%20the%20%22reason%22%20for%20your%20results%20you%20must%20explain%20with%20much%20greater%20detail%20or%20ideally%20show%20an%20example%2C%20show%20the%20power%20query%2C%20and%20a%20sample%20result.%3C%2FLINGO-BODY%3E
Occasional Contributor

I have used Power query to combine 4 tabs into one tab. I made sure all the columns are same. But when I combine the tabs, power query is giving an extra column. It is repeating the same column twice. What can be the reason?

4 Replies
It is not technically possible to answer this question without more information. "extra column" and "repeating the same column twice" have absolutely no meaning without context. Where is the "extra column" and what is "the same column twice" that is repeated. To determine the "reason" for your results you must explain with much greater detail or ideally show an example, show the power query, and a sample result.

@ravikumarnv60 

If we speak about appending the tables please check there are no spaces and like in column names ("ABC" and "ABC "), i.e. they are not only looks as the same but actually same.

Thank You it worked

@ravikumarnv60 , glad to help