salahuddin
Member
I WANT TO ARRANGE THE ROW NAME "INCOME" IN COLUMN "B" BEFORE THE ROW NAMED "EXTERNAL SECTOR"
ARRANGE DATA
- Thread starter salahuddin
- Start date
NARAYANK991
Excel Ninja
Hi ,
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.
Narayan
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.
Narayan
salahuddin
Member
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 want to cut the row name "income" and paste before the row name "external sector". Is there any formula to do this at once.
NARAYANK991
Excel Ninja
Hi ,
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.
Narayan
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.
Narayan