Different data in the same column

[Syndicate_Admin]

Hello. I'm new to power query and need help solving the following:

I extract xml documents from invoices on trailer transfers, which entail origin and destination, at the time of opening this data, they are placed in a column and use the source in one row and the destination in another, so I would like to have only one column for the destination and another for the source. I would appreciate your help.

[Anonymous · Accepted solution]

Hi @Anonymous ,

You'd better have a column about distinguishing between destination and source.

Like the following, 1 represents the destination and 2 represents the source.

Then select column A, click Pivot Column, set it as below, click OK.

Now you can see, column1 has destinations and column2 has sources.

By the way, I helped you move your post to the Power Query forum. Next time when you have questions about Power Query, please go to the Power Query forum to ask. Asking questions in the right forum will make you get help faster.

Have a nice day!

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks a lot!

[parry2k]

@Syndicate_Admin probably you need to pivot your data. Pivot columns (Power Query) (microsoft.com)

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!