+ Reply to Thread
Results 1 to 5 of 5

How to automatically sort out data and put into a new worksheet.

  1. 04-09-2012, 10:47 PM #1
    David_72
    David_72 is offline
    Registered User
    Join Date
    04-09-2012
    Location
    Wuhan, P.R.China
    MS-Off Ver
    Excel 2010
    Posts
    7

    Red face How to automatically sort out data and put into a new worksheet.

    I have one worksheet named "input" listed data in two columns, how can it automatically sort out the data and input into another worksheet looks like "output" sheet? By formula, VB, I am really bad on that...
    Thanks so much in advance!

    Input screen:

    Name Elements
    David A
    David B
    David C
    David F
    Andy A
    Andy E
    Andy F
    Andy G
    Ray B
    Ray D
    Ray F
    Ray G

    Output screen:
    output.png
    Attached Files Attached Files
    Last edited by David_72; 04-09-2012 at 11:01 PM. Reason: Looks not straight
    Reply With QuoteRegister To Reply
  2. 04-09-2012, 11:59 PM #2
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,584

    Re: How to automatically sort out data and put into a new worksheet.

    Try
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 04-10-2012, 12:14 AM #3
    JieJenn
    JieJenn is offline
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: How to automatically sort out data and put into a new worksheet.

    Use pivot table.
    Attached Files Attached Files
    Learn Data Analysis or Excel youtube.com/jiejenn
    Reply With QuoteRegister To Reply
  4. 04-10-2012, 03:15 AM #4
    David_72
    David_72 is offline
    Registered User
    Join Date
    04-09-2012
    Location
    Wuhan, P.R.China
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: How to automatically sort out data and put into a new worksheet.

    Thanks so much, Pivot table working perfect!
    Reply With QuoteRegister To Reply
  5. 04-10-2012, 03:15 AM #5
    David_72
    David_72 is offline
    Registered User
    Join Date
    04-09-2012
    Location
    Wuhan, P.R.China
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: How to automatically sort out data and put into a new worksheet.

    Thanks so much!
    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)

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