Forum Discussion

tm9918's avatar
tm9918
Frequent Visitor
6 years ago

Add alternate row data in 2 new column

I have a data like below- Name Value   Service 1.60E+12 EPOCH Time Service 1094329.332 Resp Time Service 1.60E+12 EPOCH Time Service 1065677.9 Resp Time Service 1.60E+12...
Need Help
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
6 years ago

You need to identify each pair.

 

In Power Query:

First, assign a name to the 3rd column.  Let's call it 'alt'

Add an Index column from 0.

Add a custom column , dividing the index by 2 (each Number.IntegerDivide([Index], 2))).

Remove the Index column.

Pivot on the 'alt', using Value column for Values.  I don't think it matters which aggregation you use.

 

Good luck.

tm9918's avatar
tm9918
Frequent Visitor
6 years ago

HotChilli - How can I do 'dividing the index by 2 (each Number.IntegerDivide([Index], 2)))'

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    6 years ago

    tm9918 

     

    A bit of effort required at your side.  The code is provided.  Add a custom column.  Paste some code.  Debug it if it doesn't work.

     

    I will help you if required.