Make a new list by their categories

[tonny_hartono]

Hai,

I have a list around 250 name of people with their type of payment and value.
On the next sheet of database, I want to make a new list that pick up from database, but only people who had a transfer type of payment.
On the last sheet I want to make another list that only containing only people who had cash type of payment.
I want the new list is sort without any blank cell.

Can somebody help me?

[oeldere]

Maybe with an pivot table.

See the attached file.

Please reply.

[tonny_hartono]

thank you oeldere,

it's works....

[oeldere]

Thanks for the reply.

Glad I could help.

You can add rep(utation)points to the one's who helped you by clicking on the star on the left side.