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