Hi Doug. Thanks for the M code to do this. My first pass was with the UI, as in: Demote Headers; Transpose Table; Filter Rows (filter out begins with "Column"); Transpose Table; Promote Headers; Close and Load. Your M code is much more efficient. Always learn something new from you :)) Thumbs up!!
Hi doug ... Is it possible for you to show a solution for the below...??? If i have a column with below data in column 1 how can it be converted to data in column 2 Column1. Column 2 A A A B A C A A B B B C B And so on B C C C C
Hi Doug. Thanks for the M code to do this. My first pass was with the UI, as in: Demote Headers; Transpose Table; Filter Rows (filter out begins with "Column"); Transpose Table; Promote Headers; Close and Load. Your M code is much more efficient. Always learn something new from you :)) Thumbs up!!
Thanks Wayne. I think I got this idea from Gil Raviv's book and it was to good not to share!
Thanks!!! For sharing . had been looking for it!!
No problem!!
Great, i liked. Thanks Doug!
Hi Luciano, glad you enjoyed it!
Thanks for sharing
You’re welcome!
Hi doug ... Is it possible for you to show a solution for the below...???
If i have a column with below data in column 1 how can it be converted to data in column 2
Column1. Column 2
A A
A B
A C
A A
B B
B C
B And so on
B
C
C
C
C
Not sure on your exact use case, but try grouping
th-cam.com/users/DougHExcelsearch?query=power%20query%20group
The intellisense bug is really annoying!
Why can't microsoft fix it, I wonder