CODEWITHSUNDEEP
excel
Esteban Chamard
Esteban Chamard

Reputation: 100

Split a row to create multiple couple

I'm trying to split a row in excel:

Example of my Excel

To look like this:

Exemple of my output

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

Upvotes: 0

Views: 47

Answers (1)

virtualdvid
virtualdvid

Reputation: 2411

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:

  1. Select [Numero ID Contacto].
  2. Go to Transform tab and look for Unpivot Columns.
  3. Select Unpivot Other Columns.
  4. 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.

Upvotes: 1

Related Questions