Diplay data from vertical to orizzontal

[XLalbania]

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

[¯\_(ツ)_/¯]

This macro may work for you

Please Login or Register  to view this content.

[XLalbania]

Thank you ¯\_(ツ)_/¯ for your Help
but since i'm studing Excel formulas i prefer formula, my bad if i didn't tell you before sorry

[Pete_UK]

As you are not using column B, you can put this formula in B2 (you might need to widen the column slightly to see the three-digit number it produces):

=IF(A2="","",IF(ISNUMBER(MATCH(A2,$C$1:$G$1,0)),(INT(MAX(B$1:B1)/100)+1)*100,B1+1))

and copy the formula down to the bottom of your data. Then you can put this formula in C2:

=IFERROR(INDEX($A:$A,MATCH(COLUMNS($C:C)*100+ROWS($1:1),$B:$B,0)),"")

Copy that formula into D2:G2, then copy C2:G2 down until all values returned are blanks (i.e. row 11 in this case, but it doesn't matter if you copy beyond that).

Hope this helps.

Pete

[XLalbania]

Woow Pete_UK
This great formula, now is time to study it
Thankyou for your Help
I put Solved but don't close this topic there might be Other formula solution
Thank you everybody