I am not sure what you want , since this question has been posted in the Discuss Data Visualizations and Charting section of this forum.
Can you not add a helper column , and then sort your data using this column ?
See the attached file for the formula in the helper column ; if you do a sort on this helper column , the rows which have INCOME in column B will be placed before the rows which have EXTERNAL SECTOR in the same column.
Thank u very much NARAYANK991,
I want to cut the row name "income" and paste before the row name "external sector". Is there any formula to do this at once.
I doubt that there is a formula which can do what you want , unless you want this done on a different worksheet or a different region of this worksheet ; that worksheet / region will have formulae which will rearrange your data.