Like @Krishnadditya mentioned, Collections aren't ideal for sorting because they contain items of type `Object` which is too genereic to be useful in comparing against each other.  If you weren't married to a collection, you can do this with a LINQ query to a list or anything that can be cast an enumerable



    Dim list = {
            New With {.Object = "b", .Key = "b1"},
            New With {.Object = "a", .Key = "a1"},
            New With {.Object = "d", .Key = "d1"}}

    Dim sortedList = _
            From item In list
            Order By item.Key

How do I sort collection items by value in VB.NET?

I want to sort this:

    Dim col as Collection = New Collection
    col.Add("b","b1")
    col.Add("a","a1")
    col.Add("d","d1")

VB.net, How to sort collection items by value

Sort normally by highlighting the column and Hit <kbd>Alt</kbd> + <kbd>A</kbd> + <kbd>SA</kbd>

-----

## Update:

[`'Excel sorts alphanumeric text left to right, character by character'`][AlphaNumericSort], so it may not properly order your numbers if combined into a single cell.  You should create an extra column with just the two letter code that you want to use for sorting by using `=LEFT(A2,2)` and copying all the way down.  Then do a multilayered sort by clicking the sort button, sorting first on the two digit code alphabetically and second on the number column:

![example](http://i.imgur.com/5M4WSCr.png)

[AlphaNumericSort]: http://support.microsoft.com/kb/322067#MT0

I have two columns I want to sort.  I want it to look exactly like below with Column A first sorted by its first two letters, then by Column B.


    Column A     -    Column B
    AB - Info         3339876
    AB - Data         3339877  
    AB - Data         3339878 
    AC - Info         3339123
    AC - Data         3339124
    AC - Info         3339125
    AD - Info         3339456
    AD - Info         3339457
    AD - Data         3339458

The first two letters of Column A are the MOST important and must be sorted by them first.  The information after the first two letters of Column A is irrelevant and does not matter. It is much more important that the Column B # data to be sorted in ascending order second (after the first two letters of column A)

Sorry for the confusion. Hopefully that clears things up.

Excel VBA - How to sort by first two letters of cell?

I have a tablix control with multiple header rows.  There are no groupings; the extra rows are just for the visual effect of displaying information.

I've followed the instructions for [how to add Interactive Sort to a Table or Matrix][1].

I've gone to the textbox in the header (also tried doing the same to all three) and gone to properties:

&nbsp;&nbsp;![Properties](http://i.imgur.com/diAutxC.png)

And then enabled Interactive Sorting:

&nbsp;&nbsp;![Interactive Sort](http://i.imgur.com/vnQhDeW.png)

If I only have a single header row, it works and looks like this:

&nbsp;&nbsp;![Expected](http://i.imgur.com/GM8aboc.png)

But it actually looks like this:

&nbsp;&nbsp;![Actual](http://i.imgur.com/7RoO3uY.png)

Can I add interactive sorting when there are multiple rows?

**Potential Workaround**: The only thing I thought of would be to add the sort fields as a parameter to the report and set the sorting at the Tablix level as an expression based off that.  But I like the organic look and feel of inline sorting.

[1]: http://technet.microsoft.com/en-us/library/cc627509.aspx

Sortable columns on Tablix with multiple header rows

Given the following input:

```js
let classes = {
  'class-1': {name: 'P.E.', completed: '12/02/19', letterGrade: 'A'},
  'class-2': {name: 'English', completed: '12/02/19', letterGrade: 'A'},
  'class-3': {name: 'Math', completed: '12/02/19', letterGrade: 'A'},
}
```

You can separate each key/value pair into entries, sort those entries however you wish, and then re-assign to an object, like this:

```js
let allEntries = Object.entries(classes)
let sortedEntries = allEntries.sort((a,b) => a[1].name.localeCompare(b[1].name))
let obj = Object.fromEntries(sortedEntries)
```

Which will produce the following result:

```js
{
  'class-2': {name: 'English', completed: '12/02/19', letterGrade: 'A'},
  'class-3': {name: 'Math', completed: '12/02/19', letterGrade: 'A'},
  'class-1': {name: 'P.E.', completed: '12/02/19', letterGrade: 'A'}
}
```

Although do note that [insertion order is not deterministic for js object properties](https://stackoverflow.com/q/52119625/1366033)

### Demo in Stack Snippets





    let classes = {
      'class-1': {name: 'P.E.', completed: '12/02/19', letterGrade: 'A'},
      'class-2': {name: 'English', completed: '12/02/19', letterGrade: 'A'},
      'class-3': {name: 'Math', completed: '12/02/19', letterGrade: 'A'},
    }

    let allEntries = Object.entries(classes)
    let sortedEntries = allEntries.sort((a,b) => a[1].name.localeCompare(b[1].name))
    let obj = Object.fromEntries(sortedEntries)

    console.log(obj)

So I have this array that contains objects:

```js
var terms = [
 {
  'class-1': {name: 'English', completed: '12/02/19', letterGrade: 'A'}, 
  'class-2': {name: 'Math', completed: '12/02/19', letterGrade: 'A'},
  'class-3': {name: 'P.E.', completed: '12/02/19', letterGrade: 'A'},
  'class-4': {name: 'World History', completed: '12/02/19', letterGrade: 'A'}
 },
 {
  'class-1': {name: 'P.E.', completed: '12/02/19', letterGrade: 'A'},
  'class-2': {name: 'World History', completed: '12/02/19', letterGrade: 'A'},
 },
 {
  'class-1': {name: 'P.E.', completed: '12/02/19', letterGrade: 'A'},
  'class-2': {name: 'English', completed: '12/02/19', letterGrade: 'A'},
  'class-3': {name: 'Math', completed: '12/02/19', letterGrade: 'A'},
 },
 {
  'class-1': {name: 'English', completed: '12/02/19', letterGrade: 'A'},
  'class-2': {name: 'Algebra', completed: '12/02/19', letterGrade: 'A'},
  'class-3': {name: 'Psychology', completed: '12/02/19', letterGrade: 'A'},
 }
]
```
And I want to sort each of the nested objects alphabetically on the name of the class. But I want the whole array to be sorted.

Not sure how I should go about doing this. What's holding me up is the amount of nests in the data.