Split a row to create multiple couple

Question

I'm trying to split a row in excel:

To look like this:

By the way I have a lot of row and column

I'm not very clear, and I don't know how to explain this in a better way

Answer 1

You can use Power Query it is an add-in that you can download and install easily, in Excel 2016 is a default in Data tab:

1. Go to Power Query tab or Data Tab and select From Table/Range. OK.

It will open the Query Editor, there:

2. Select [Numero ID Contacto].
3. Go to Transform tab and look for Unpivot Columns.
4. Select Unpivot Other Columns.
5. Go to Close and Load in Home tab.

It will create a new table with your data transformed.

I made this Tutorial. It is in Spanish but I am using the English Excel version.