Summary of rows

[Mr-Re Man]

***IF THIS IS DUPLICATED, PLEASE EXCEPT MY APOLOGIES, I RECEIVED AN ERROR ON
CLICKING SUBMIT***

I have a worksheet with 22000 rows on mobile telephone calls made with
various items of data, name, mobile number, number called, cost, type of
call, section etc.

I would like to just reduce the list quickly to show name, section.

I can do this by deleting rows, but it will take forever. I have tried a
pivot table, but cannot seem to remove each rows total, I have tried subform
but I cannot get it to display section, name will as it is the first column.

Any ideas?

 

[Sean Timmons]

To get rid of subtotals in a pivot table, right click on the row field and
click None under Subtotals...

 

[Gary''s Student]

If you post a small sample of your data, both as it appears and your desired
result, we can guide you.