Forum Discussion
Repeat Cell Values
Hello all, I am trying to transpose data in a way that is more readable for a software I will be using. I have attached an image that contains what the current table looks like, and then the des...
An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
Thank you! What if I wanted to expand the table by a few columns and rows? Would I have to change the code in the query?