Separate Tabs for Separate Fields

[DataPirate26]

Hello,

I want to create 3 different tabs for 3 different field. Can anyone help me out with this. 

Test file attached below. I want 3 tabs for the given 3 fields -  Director , Average and Popular 

[DataPirate26]

Hello,

I want to create 3 different tabs for 3 different field. Can anyone help me out with this. 

Test file attached below. I want 3 tabs for the given 3 fields -  Director , Average and Popular 

[binu_acs · Accepted solution]

@DataPirate26 

[Qiu · Accepted solution]

@DataPirate26 
I think you might want the same for the column header. 
So I choose a Macro approach.

[DataPirate26]

@binu_acs @Qiu Both did work. Thank you for assisting

[Qiu · Accepted solution]

@DataPirate26 
You are welcome. and thank you for the accept mark.