# Make an excel table sort diffrently

##### New Member
 01/07/2016 Maier, Sabine winter appeal 100 01/08/2016 Richter, Judy winter appeal 100 01/08/2016 Salem, Margo winter appeal 25 01/08/2016 Andrew, Samuel winter appeal 500 04/05/2016 Maier, Sabine spring appeal 75 04/05/2016 Richter, Judy spring appeal 50 04/05/2016 Salem, Margo spring appeal 50 04/05/2016 Andrew, Samuel spring appeal 100 07/01/2016 Maier, Sabine gala 75 01/07/2016 Richter, Judy gala 50 01/07/2016 Salem, Margo gala 50 01/07/2016 Andrew, Samuel gala 100

<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

I would like it to be like this
winter appeal spring appeal gala
 Maier, Sabine 100.00 75.00 75.00 Richter, Judy 100.00 50.00 50.00 Salem, Margo 25.00 50.00 25.00 Andrew, Samuel 500.00 100.00 100.00 any chance? THANKSSSSSSSSSSSS

<tbody>
</tbody>

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

#### Michael M

##### Well-known Member
you'll probably need VBA to do this
Try this on a copy of your worksheet

Code:
``````Sub MM1()
Dim lr As Long, r As Long
lr = Cells(Rows.Count, "A").End(xlUp).Row
With Sheets("Sheet1").Sort
.SetRange Range("A1:D" & lr)
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
For r = lr To 2 Step -1
If Range("B" & r).Value = Range("B" & r - 1).Value Then
Range("D" & r - 1).Value = Range("D" & r - 1).Value & " " & Range("D" & r).Value
Rows(r).Delete
End If
Next r
End Sub``````

#### frank_AL

##### Active Member
The simplest way that would get very close to what you are showing would be to create a Pivot Table.

Replies
11
Views
305
Replies
6
Views
646
Replies
4
Views
484
Replies
6
Views
738
Replies
5
Views
895

1,191,418
Messages
5,986,451
Members
440,031
Latest member
davidvillegasr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back