Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Transformed table loses column order

I have three different spreadsheets that I am combining in a Union table.  The spreadsheets share some common data, however, the column names are different and the column orders are different.  I am ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    Anonymous 

    Thanks for the images. I see what you mean now. 

    Is there a specific reason you need all tables to show the columns in the same order?

    BTW, you might consider actually appending the region tables (China EMEA, Americas) into one single table in Power Query (which will make life easier further down the road when using measures, creating visuals etc)

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous 

Thanks for the images. I see what you mean now. 

Is there a specific reason you need all tables to show the columns in the same order?

BTW, you might consider actually appending the region tables (China EMEA, Americas) into one single table in Power Query (which will make life easier further down the road when using measures, creating visuals etc)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

That's got it.  learned something new.  Somebody else recommended a Union table. When I use append it brings them together nicely.

 

Thanks