move one line after another

[alex753]

hi, as a new Power BI and Power Query user, I understood that it was not possible to move the rows of a table, but I prefer to ask if it was possible to move one row after another.
Here's an example of what I'd like to do:
I'd like to place my rows 5-6 after my rows 2-3.
How do I do this?
I'm attaching 2 screenshots to illustrate my request.

thank you in advance for your help.

 

[Anonymous · Accepted solution]

Hi @alex753 ,

Here's the sample data:

Steps:

1.Remove blank rows and then duplicate the table.

2.In the first table, remove the bottom 2 rows, in the second table, remove top 2 rows.

3.For both two tables, use the first row as headers. And then add a custom column to add the Table(2).

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[alex753]

thanks 

[lbendlin]

That is a very unfortunate input format.  Is that something you can influence or is that how you need to use it?

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...