+ Reply to Thread
Results 1 to 2 of 2

Hi, Need help on Data Arrangements

  1. 08-28-2017, 12:47 AM #1
    exceldoubts
    exceldoubts is offline
    Registered User
    Join Date
    12-04-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    31

    Hi, Need help on Data Arrangements

    Please find attach sheet. I want data in the column A goes in the form as shown in the sheet (From Column B to Column I). I have 1000 data like this. It would be great help if someone provide me solution to this.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-28-2017, 10:01 AM #2
    JeteMc
    JeteMc is online now
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,903

    Re: Hi, Need help on Data Arrangements

    The formulas work for the data provided in the sample file attached to post #1.
    There are several formulas however they all share the goal of finding the correct row as in the formula for 'Company Name':
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Data Challenge: turning massive amounts of sales order data into summarized customer data
    By amiller in forum Excel General
    Replies: 34
    Last Post: 01-21-2014, 03:07 PM
  2. How do I generate all possible unique arrangements of 5 numbers
    By jazzahanna in forum Excel General
    Replies: 21
    Last Post: 12-09-2013, 03:03 PM
  3. Identical worksheets, identical data, different arrangements
    By Hooty in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-21-2012, 05:02 PM
  4. [SOLVED] Searching A Number at any arrangements
    By Jerry HKA in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 10-03-2012, 09:12 PM
  5. Need help in complicated Nested Function to change arrangements of data display
    By sheclaire in forum Excel General
    Replies: 8
    Last Post: 09-11-2011, 01:21 AM
  6. Comparing Data in Two Different Arrangements
    By tc177 in forum Excel General
    Replies: 5
    Last Post: 05-25-2010, 02:32 PM
  7. all arrangements of 8 letter words with 3 symbols
    By rohed in forum Excel General
    Replies: 2
    Last Post: 03-12-2007, 05:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1