Query Editor: Field values as separate records

[bullius]

Hi,

I have data that looks like this:

CompanyID	OfficeAddressID	MeetingAddressID	ShopAddressID
1	1	6	null
2	null	4	null
3	7	2	12
4	null	null	3
5	8	9	15

I would like it to look like this:

CompanyID	AddressID	AddressType
1	1	Office
1	6	Meeting
2	4	Meeting
3	7	Office
3	2	Meeting
3	12	Shop
4	3	Shop
5	8	Office
5	9	Meeting
5	15	Shop

Basically, I want to turn each company's address IDs into separate records.

Anyone know how to do this within Query Editor?

Thanks!

[MFelix · Accepted solution]

Hi @bullius,

Select all the columns except the Company ID and do Unpivot columns the result will be as show below:

Regards,

MFelix

[bullius]

Thanks @MFelix

I knew there had to be a simple solution!