1

I have an excel sheet like this:

|  Time   |  Network1  |  Network2  |  ...  |  Networkn  |
|---------|------------|------------|-------|------------|
|  00:00  |  23.424    |   12323    |  ...  |  412       |
|  00:05  |  3112      |   1322     |  ...  |  123       |
|  ...    |  ...       |   ...      |  ...  |  ...       |
|  23:55  |  1321      |   4124     |  ...  |  214       |

where the values of each network column is the traffic for that specific time.

I want to re-arrange the data so it will create something like this:

|  Time   |  Networks  |  Traffic   |
|---------|------------|------------|
|  00:00  |  Network1  |   23.424   |  
|  00:00  |  Network2  |   12323    |  
|  ...    |  ...       |   ...      |  
|  23:55  |  Networkn  |   214      |

It's like groupby(Time, network_names, traffic_of_each_network_per_Time).

I was playing with the PivotTable Fields but didn't figure it out yet.

Any ideas?

3
  • looks like you need to unpivot the data, you can do this with Power Pivot
    – PeterH
    May 14 '19 at 10:14
  • Hey @PeterH thanks for commenting. I am afraid I can't get access to the Power Pivot Add-In to check how I can do this. can you think of any other work-arounds?
    – Lev
    May 14 '19 at 10:31
  • use Power Query to unpivot your data. Since Excel 2016 it's fully integrated in Excel (known as Get & Transform)
    – visu-l
    Jun 4 '19 at 5:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.