query edit, fill down problem

[blazko]

Hi, i have a small problem with data modellin in query editor. The exampel screen explains what i need to do. I have a table with cient data one under another, and i need to put them in separate column, as shown above, The question is how? Thx in advance for any help.

[v-piga-msft · Accepted solution]

Hi  @blazko,

There are some steps to get your expected output.

You could have a reference of the steps in Query editor. Here is my test pbix file.

Best regards,

Cherry