+ Reply to Thread
Results 1 to 4 of 4

Need help on how to filter this

  1. #1
    Registered User
    Join Date
    02-09-2020
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    2

    Unhappy Need help on how to filter this

    Hi, this is my first time posting here so I am not sure if this is the right section.

    But i attached a sample of a document that i do not know on how to filter it or tabulate it so i can understand it better.

    I tried Text to Column but maybe I am not doing it right.

    Please help,anyone..

    Thank you so much!
    Attached Files Attached Files

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,773

    Re: Need help on how to filter this

    Hi,

    Does this look fine? It looks as some headers might be here and there, but overall looks fine to me.

    I basically concatenated each row from Columns A through G and then used TextToColumns using ; as delimiter
    Attached Files Attached Files
    Cheers!
    Deep Dave

    www.NeedForExcel.com

  3. #3
    Registered User
    Join Date
    02-09-2020
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    2

    Re: Need help on how to filter this

    Yes, this is awesome!

    I just don't know how to sort it like that.

    Can you teach me how to do that concatenate, what do i need to input.I am not familiar using concatenate yet.

    Thank you so much!

  4. #4
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,773

    Re: Need help on how to filter this

    Hi,

    Basically use the Concatenate function and click on each cell from the 1st Data Row > PasteSpecial Values and put that on a different sheet > Then use TextToColumns

+ 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