CODEWITHSUNDEEP
excelpowerquery
R. Dawg
R. Dawg

Reputation: 21

How to avoid having Power Query reorder my data when merging queries/expanding

I have mismatched data lines in a power query so I am attempting to renumber/reorganize the data then merge the information to realign.

Here, I want the data in Column Answer 2 to go into column Answer, cells 6,7,11,12.

Screenshot 1

I've indexed each of my files and merged the queries. However, when I expand the merged queries, PQ seems to randomize my data.

Screenshot 2

I'm new to PQ so I don't really write the 'code', just use the user interface.

As you can see from the second image, the data comes out in the wrong order.

Upvotes: 2

Views: 5754

Answers (1)

Elina Duchess
Elina Duchess

Reputation: 59

I merged two tables, then added index column and moved it to the beginning, then expanded the merged table and deleted index column. The order of rows has left the same, as in the source table.

Upvotes: 5

Related Questions