Split the data into multiple sheets

In this video, I am trying to tell you that I want data department wise.
I used a pivot table for the same.

Separate the data into different sheets according to column requirement

#excelfriendship
#exce
#friendship
#dataseparation

[aimranbcs]

Thank you for sharing the video it's been most helpful

[stbalongo]

Thank you so much. This was very helpful