Group data (addresses) from two rows into one but with separate columns - going mad!

[WingsGSE]

Hi!

I am using data imported from our SQL server - it's showing the Collection address (6 columns) and Delivery address (6 columns) in two separate tows, with the job ID as the common denominator. I need to group these into one row but separate columns (such that I can then rename them as Collection Address 1, 2, 3, Collection City, Delivery Address 1, 2, 3, Delivery City etc) on one row.

Id	JobId	AddressType	Address1	Address2	Address3	City	State	PostalCode
4387	2197	0	123 Road	123 Street	123 Address 3	City	State	AB12 3CD
4388	2197	1	456 Road	456 Street	456 Address 3	City	State	EF45 6GH

I have been attempting this with the Group By function but I'm going wrong somewhere as it's mixing up the two addresses.

Can anyone kindly point me in the right direction?

Thanks!

[rsbin · Accepted solution]

@WingsGSE ,

This can be done in Power Query using the Merge Queries function.

I have attached a pbix file so you can easily see the steps to accomplish your ask.

Hope this is the result you are looking for.

Regards,

[WingsGSE]

I cannot thank you enough!

[rsbin]

@WingsGSE ,

You just did.

Thx and Best Regards,