Hello Excel friends
I'm tring do dispaly the animals from vertical to orizontal, as you can see from the image I've the original data in colum A and I need to showup like in columw C,D,E,F,G

Thank you for your help

A
B
C
D
E
F
G
1
List
 Employ 1 Employ 2 Employ 3 Employ 4 Employ 5
2
 Employ 1 dog badger bullock fox mammoth
3
 dog cat bat camel gazelle marmot
4
 cat armadillo bear chimpanzee gerbil mink
5
 armadillo beaver dachshund giraffe mole
6
 Employ 2 goat mongoose
7
 badger grizzly bear mouse
8
 bat guinea pig mule
9
 bear hamster
10
 beaver hare
11
 Employ 3
12
 bullock
13
 camel
14
 chimpanzee
15
 dachshund
16
 Employ 4
17
 fox
18
 gazelle
19
 gerbil
20
 giraffe
21
 goat
22
 grizzly bear
23
 guinea pig
24
 hamster
25
 hare
26
 Employ 5
27
 mammoth
28
 marmot
29
 mink
30
 mole
31
 mongoose
32
 mouse
33
 mule