Grouping Upside Down - How to reverse?

[JNL74]

All the directions I have found on line for reversing the direction of the grouping, are telling me to open the box and change the direction, however, there are no additional options, there is not box to "open" there are only two options, group & ungroup. They were top to bottom, then suddenly they weren't, so I'm thinking either me or someone working on the xls fat fingered a shortcut command, like ctrl+an arrow or something? Though, I can't find a shortcut command on line either.. Help please.

 

[JNL74]

Usually gurus answer questions so fast, is this one stumping everyone? Or did I end up in a dark corner somewhere in this site? Please.. I beg of you.. help me vertically flip my groups. .

 

[Alex Blakenburg]

You might want to update your Account details to show which version of Excel you are using.
In this instance I am pretty sure you are using Web Excel (Excel Online), there are quite a number of differences between the functions available between it and the Desktop version.

The get the additional grouping options that you are after you will need to open the file in a Desktop version of Excel.
Once you have done that under the data tab you should be able to get the options shown below:

 

[xjpx]

If you are open to VBA, try this,

Sub FlipVert()

Dim Rng As Range
Dim WorkRng As Range
Dim Arr As Variant
Dim i As Integer, j As Integer, k As Integer

On Error Resume Next
xTitleID = "Flip Data Vertically"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleID, WorkRng.Address, Type:=8)
Arr = WorkRng.Formula

For j = 1 To UBound(Arr, 2)
    k = UBound(Arr, 1)
    For i = 1 To UBound(Arr, 1) / 2
        xTemp = Arr(i, j)
        Arr(i, j) = Arr(k, j)
        Arr(k, j) = xTemp
        k = k - 1
    Next
Next

WorkRng.Formula = Arr

End Sub

 

[JNL74]

I've tried that, but I will try again, I assumed that some options weren't on the o365 versions

You might want to update your Account details to show which version of Excel you are using.
In this instance I am pretty sure you are using Web Excel (Excel Online), there are quite a number of differences between the functions available between it and the Desktop version.

The get the additional grouping options that you are after you will need to open the file in a Desktop version of Excel.
Once you have done that under the data tab you should be able to get the options shown below:

View attachment 57822

It is already set to this and still upside down

 

[Alex Blakenburg]

I've tried that, but I will try again, I assumed that some options weren't on the o365 versions

It is already set to this and still upside downView attachment 57825View attachment 57826

You have the box for "below" ticked and the control is at the bottom. You need to UNtick it if you want the control at the top.