Huge data needs to be sorted

[arihanth]

Hi All,

I have a huge set of statistical data which needs to be sorted. This data is spread across multiple sheets. The format of the data is "Name (A-Z) - Type" in column A and its corresponding numerical values in arranged row wise.
eg:

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]NameA_Type1[/TD]
[TD]10[/TD]
[TD]12[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]NameA_Type2[/TD]
[TD]16[/TD]
[TD]18[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]NameB_Type1[/TD]
[TD]22[/TD]
[TD]24[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]NameB_Type2[/TD]
[TD]28[/TD]
[TD]30[/TD]
[TD]32[/TD]
[/TR]
</tbody>[/TABLE]







I need to group the data on the basis of "Type". So can someone please help me and let me know a solution other than manually finding the type and copy-paste.

Hoping for some replies.

Thanks,
Arihanth

 

[JackDanIce]

I would use two "helper" columns to the right of your data
In the first helper column enter this formula and drag to the last row: =RIGHT(A1,5)
In the second helper column enter: =ROW(), drag to the last row
Copy and paste the values in both helper columns

Now you can sort your table, by the first helper column and then by the second helper column. You can use the second helper column to "unsort" your data if you need to or you can just clear both helper columns if you no longer need them

 

[mumps]

Another approach is to use 'Text to Columns' to split column A into two parts using the underscore character as a separator. Then you can sort by column B.

 

[arihanth]

Thanks for your help and quick turn around. The solutions worked and I am able to work on my data. Thank you again

 

[JackDanIce]

You're welcome, thanks for the feedback