Forum Discussion
Power query grouping all
Hello Anonymous , after the group step that you suggested, there is a simple solution for the expand all. You need to delete the original column (In this case "Address") before it reappears with the expand step. For the expand step, here's a good tutorial on how to do it.
https://goodly.co.in/expand-all-columns-dynamically-power-query/
Thank you
Hello Anonymous , your group step works great but not the table expand column. I get an error saying that "Adresse" already exists. It seems with this method that PQ is not able to make the difference between the column that is inside the table and the one already there. It thinks it's the same.
Thank you
Hello Anonymous , after the group step that you suggested, there is a simple solution for the expand all. You need to delete the original column (In this case "Address") before it reappears with the expand step. For the expand step, here's a good tutorial on how to do it.
https://goodly.co.in/expand-all-columns-dynamically-power-query/
Thank you