+ Reply to Thread
Results 1 to 4 of 4

Region Wise - Arranging data

  1. #1
    Registered User
    Join Date
    02-21-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    56

    Region Wise - Arranging data

    Hi All,

    Kindly advise how to arrange the vendor region details in a single line using excel function.

    Thanks in advance for your help.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    650

    Re: Region Wise - Arranging data

    will your data always be sorted as it is - the first valid region ID will always be in West, then North, then South (as applicable)?

    assuming so, i've accomplished the desired result in G3:J9 in the attached with the following formulas:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    array formula (ctrl+shift enter)
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Hope I could help - if your post has been solved don't forget to mark it as such.

    Clicking the * below is a great way to say thanks!

    "Drowning in 10 feet of water isnít any different than drowning in a million feet. And if you can swim, it doesnít matter how deep the ocean is. At some level, once you realize youíre in water thatís too deep to stand, you have to have a very different approach," - Joi Ito

  3. #3
    Registered User
    Join Date
    02-21-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    56

    Re: Region Wise - Arranging data

    this is matching my requirements. Thanks a lot

  4. #4
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    650

    Re: Region Wise - Arranging data

    glad to hear it, thanks for the rep!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Arranging row wise data
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-16-2014, 08:49 AM
  2. [SOLVED] I want change the data row wise to coloum wise & coloumn wise to row wise.
    By satputenandkumar0 in forum Excel General
    Replies: 3
    Last Post: 12-20-2012, 08:34 AM
  3. sum - region wise
    By sagar in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 11-06-2006, 11:44 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1