• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

ARRANGE DATA

salahuddin

New Member
I WANT TO ARRANGE THE ROW NAME "INCOME" IN COLUMN "B" BEFORE THE ROW NAMED "EXTERNAL SECTOR"
 

Attachments

  • EXCEL HELP.xlsx
    80.7 KB · Views: 5
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
 

Attachments

  • EXCEL HELP (1).xlsx
    134.1 KB · Views: 5
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.
 
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
 
Back
Top