locked
Split rows in multiple rows by Input Value an count RRS feed

  • Question

  • In Power query I have  below date

    row GroupedId_Attribute Count_Attribute
    1 Validation      9
    2 Input     12

    I needed the columns to be split by 0, 1, 1, 2, 3, 5, 8, 13, 21, 34,
    check if the column value is Validation or Input

    I need to the output in the below format:

    row GroupedId_Attribute Count_Attribute
    1 Validation1 9
    2 Validation18       9
    3 Input2     12
    4 Input6     12
    5 Input4     12

    If I have validation 1 and Validaiton 8, it should be repeated, is there a way not to duplicate these (it should generate some other series.

    Other than fibonasis series, do we have any other way of series generation.
    Friday, January 18, 2019 7:47 PM

Answers

  • Hi NaviChandu. Can you clarify what you're trying to do? It's not clear to me from your example above.

    Ehren

    Thursday, January 24, 2019 8:31 PM