Forum Discussion
Rows not columns
MarcelBeugis correct. You will need to transpose the information in PowerQuery. Thankfully, you only have to do it once and it will continue to run.
Check out this video for a tutorial:
https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-1-5-cleaning-irregular-data/
MarcelBeugis correct. You will need to transpose the information in PowerQuery. Thankfully, you only have to do it once and it will continue to run.
Check out this video for a tutorial:
https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-1-5-cleaning-irregular-data/
Thanks! kcantor & MarcelBeug very helpful
I am assuming that as i add data to my sheet, and then hit refresh it will transpose and pull it through automatically?
The transpose as such will go fine if data is added.
However, if you have additional steps that refer to columns in the transposed table, these will go wrong in case those columns are no longer there after refresh.
One more remark to be complete: Table.Transpose has an optional second parameter in which you can define columns of the table after the transpose. In the code that is generated, this second parameter is left empty and if you keep it that way, you are good to go.
