Forum Discussion

Rygar's avatar
Rygar
Icon for Helper II rankHelper II
4 years ago
Solved

Multi transpose from one column

Hi Community!    I need some kind of multi transpose from a column: Example File here: https://edvadamsde-my.sharepoint.com/:x:/g/personal/adams_edv-adams_de/EcJEphvMqcdGo4MbaM8iMw8BJoC4iEjq...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

    just for the data you shown

    =#table(4,List.Split(PreviousStepName[Column1],4))

  • Rygar's avatar
    Rygar
    4 years ago

    Nice approach, it worked, thanks a lot!

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
4 years ago

just for the data you shown

=#table(4,List.Split(PreviousStepName[Column1],4))

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Icon for Most Valuable Professional rankMost Valuable Professional
    4 years ago

    This is awesome. Never thought of using List.Split ever. You taught me this trick. Thank you, so much.

    • wdx223_Daniel's avatar
      wdx223_Daniel
      Icon for Community Champion rankCommunity Champion
      4 years ago

      it's my pleasure.

  • Rygar's avatar
    Rygar
    Icon for Helper II rankHelper II
    4 years ago

    Thanks a lot for this elegant solution!