Hi Roy
You can drag all of your fields to the row area, and not allocate
anything to the data area.
You will then see all of the original data going across the page, in the
oder that you have arranged the fields in the row area.
Double click on each field and set the subtotal to None.
I use this as a quick and easy method of sorting out tasks, rather than
sorting and filtering data.
I have a Start Date column, Required by Date column, Task type column
and Notes column.
Getting the Required date field to be grouped by Month, then gives a
nice orderly presentation of what is to be done and when. The filter
buttons then allow me to select which, group of task I want to view.
I just hide the columns on the sheet where the PT data would normally
sit, so I don't see an empty rectangle.
