Forum Discussion
Rygar
4 years agoHelper II
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...
- 4 years ago
just for the data you shown
=#table(4,List.Split(PreviousStepName[Column1],4))
- 4 years ago
Nice approach, it worked, thanks a lot!
wdx223_Daniel
4 years agoCommunity Champion
just for the data you shown
=#table(4,List.Split(PreviousStepName[Column1],4))
- Vijay_A_Verma4 years agoMost Valuable Professional
This is awesome. Never thought of using List.Split ever. You taught me this trick. Thank you, so much.
- wdx223_Daniel4 years agoCommunity Champion
it's my pleasure.
- Rygar4 years agoHelper II
Thanks a lot for this elegant solution!