Condensing multiple data points into 2 columns?

[ahhhelen]

Hi all, I dont know if this makes sense but I'm wondering if there is an excel formula that could help make this quicker?

I have multiple domain names that need to be condensed into two columns.

For example, this is what my current data set looks like:

Company Name	Domain 1	Domain 2	Domain 3
Company 1	company1.com	company1alt.com	company1alt2.com
Company 2	company2.com	company2alt.com
Company 3	Company3.com

This is what I need it to look like:

Company Name	Domain
Company 1	company1.com
Company 1	company1alt.com
Company 1	company1alt2.com
Company 2	company2.com
Company 2	company2alt.com
Company 3	Company3.com

Any help or suggestions would be greatly appreciated!

 

[alansidman]

With Power Query, you can load your data to the PQ editor and then Unpivot your data.

 

[ahhhelen]

With Power Query, you can load your data to the PQ editor and then Unpivot your data.

oh my god thank you so much