excel filter not working extra rows appearing

Select the data you want to split. After that workbookactive selects the first available sheet and in this case you can see that …