Sort range with unknown size and values (in columns)

[shahsad]

Hello forum community,

I am currently starting with Excel vba.

I would like to describe my sorting problem directly with an example:

Different anglers have caught different fish.
In column D&E are name and city, in an unknown area are the fish that were caught and behind that comes their experience.
(in the best case the column with experience should stay behind the catch).

My goal is
To add all different and occurring fishes each as a heading in an own column and to sort the fishes in the right column in the area.

I have tried but have not found a solution.
Can you please help me with a code?

thousand thanks

 

[shahsad]

To show you what my goal is:
in the picture is what I want to have in the end.
thanks a lot!