Change Row position in a table

[adarsh2608]

Hello,

I want to move a row from a table to bottom of the table , as example in the below excel  Data4 is row5 , but it to move to row7 (last row)

[DataNath · Accepted solution]

Hey @adarsh2608 I think you provided your desired output as the sample so Data4 was already at the bottom. Instead, I shifted 'Data2' to the bottom. You can simply do this by splitting off the record in question (just change what is in quotations in the Filter tool) and then unioning it back to the main dataset with a specified order as shown below (workbook attached):

[adarsh2608]

@DataNath 

ya it was helpful, Thank you

[Kurohits]

Hi @adarsh2608 

Bit late for this post and you already got the solution by @DataNath. Just wanted to share another simple method to achieve the output. Please have a look. I hope this helps. 

Thanks 

Rohit Gupta