Moving Multiple Rows in Pivot Table

[bg]

I need to move multiple rows at a time within a table rather than being able to select only one row and move it just one row at a time if they don't belong at the beginning or end.


The issue is where numbers currently sort this way

24.B

24.C

3.A.i

3.A.ii

and I want the last two rows to be above the first two. How can I move the 3.A rows above the 24 rows?

 

[asa]

Easiest would be to change your data so the numbers are padded with spaces to the same length (a space before the 3). That should resolve the sorting for the first level of hierarchy. Still an issue with roman numeral sorting, though.


Could you keep the the hierarchy levels in three separate cells?


Asa

 

[bg]

Thanks. I found out an easy method. Select/highlight the cells; hover to get the crosshairs; drag to the desired location. This is far superior to right clicking and moving one row at a time.