Forum Discussion
Convert all the rows to column
Hi All, I have data rowwise but i want to change into columns wise like single ID having process steps with data time so i want to convert using power query. expected like: input 1 and ...
Your proposed structure isn't great for analysis. Instead, you should unpivot the IN/OUT columns. You can then get your desired view by using both the Process and new unpivoted IN/OUT column in the Columns field well of a matrix visual. I couldn't easily extract your sample data as an image, so couldn't provide a specific example/demo.
Pat