Restructuring a table

[Nub]

Hey everyone!

So I have this excel sheet which looks like this (replaced the data cuz it's sensitive, also the actual sheet is 8000+ records which is why I need the following automated):

EXCEL_07h5xmN6gA.png

The problem is now that I can't figure out how to convert above image to following image (again, it's for 8000+ records)

EXCEL_A3rWPjU35r.png

Anyone have any idea on how to get this done?

Thanks in advance!!

[Czeslaw]

Formula

Please Login or Register  to view this content.

[Nub]

Hey! Thanks for your response!

Is there a way to do this, regardless of the amount of column sets there are.

For example, if there was another name, street, city, zip, phone, email and site?

[Czeslaw]

See Sheet1 with the formula

Please Login or Register  to view this content.

[Nub]

Thank you for replying Czeslaw!

Your last answer didn't answer my question though.

I need it to work, regardless of the amount of contacts.

Above answer will only work with 2 contacts

Is it possible to do it with 7 for example?

[Czeslaw]

It may be possible to carry out such a restructuring in power query, with formulas too, but this, as I imagine, is very difficult.

[Metoo7]

You can restructure the table with Pivot Table easily.