+ Reply to Thread
Results 1 to 8 of 8

How to sort wthout doing the final manual manipulations?

  1. #1
    Forum Contributor
    Join Date
    10-24-2012
    Location
    malaysia
    MS-Off Ver
    Excel 2021
    Posts
    114

    How to sort wthout doing the final manual manipulations?

    Want to sort data according to their date but normal sorting will not put all the data of the same date into the same row. See attachment.

    Please advise/help.

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: How to sort wthout doing the final manual manipulations?

    Arrange your data and use pivot table for getting the desired result. Refer the attached file for solution
    Attached Files Attached Files


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Valued Forum Contributor
    Join Date
    10-29-2012
    Location
    Mojokerto,Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    552

    Re: How to sort wthout doing the final manual manipulations?

    see attachment solution sheet

  4. #4
    Forum Contributor
    Join Date
    10-24-2012
    Location
    malaysia
    MS-Off Ver
    Excel 2021
    Posts
    114

    Re: How to sort wthout doing the final manual manipulations?

    Quote Originally Posted by :) Sixthsense :) View Post
    Arrange your data and use pivot table for getting the desired result. Refer the attached file for solution
    Many thanks.

    Tried it but due to my 8000+ rows of data, it came up with an error.

    Found a way around the problem.

    Sort it the normal way ending up with 2 rows of the same date (I want only 1 row per date).

    I copy, transpose the data, shift the second row to the left by 1 cell and then transpose again back to the column mode. Then I have 2 data per date row.

    Many thanks for your help.

  5. #5
    Forum Contributor
    Join Date
    10-24-2012
    Location
    malaysia
    MS-Off Ver
    Excel 2021
    Posts
    114

    Re: How to sort wthout doing the final manual manipulations?

    Quote Originally Posted by Ghozi Alkatiri View Post
    see attachment solution sheet
    Thanks!

    Too advanced for me. Will try it out.

    Cheerio.

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: How to sort wthout doing the final manual manipulations?

    8000 rows of data is nothing for pivot...

  7. #7
    Forum Contributor
    Join Date
    10-24-2012
    Location
    malaysia
    MS-Off Ver
    Excel 2021
    Posts
    114

    Re: How to sort wthout doing the final manual manipulations?

    Quote Originally Posted by :) Sixthsense :) View Post
    8000 rows of data is nothing for pivot...
    Will try again later and close all other programs. I am using Vista with 2 GB RAM. Should be enough in my view.

    Cheerio.

  8. #8
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: How to sort wthout doing the final manual manipulations?

    It is more than enough

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1