How to convert repeated lines content to other column

Something like this.....
To give you an idea, please refer to the data in the following table.

	A	B	C	D	E	F	G	H	I
1	Type	Item
2	Vegetable	Broccoli		Fruit	Apple	Mango	Grapes	-	-
3	Fruit	Apple		Vegetable	Broccoli	Spinach	Pumpkin	Potato	-
4	Vegetable	Spinach
5	Fruit	Mango
6	Vegetable	Pumpkin
7	Fruit	Grapes
8	Vegetable	Potato

Array Formulas are used. Array Formula requires special key strokes Ctrl+Shift+Enter instead of just Enter. i.e. after typing the formula in the formula cell, don't press Enter alone but hold down the Ctrl+Shift keys together and then hit Enter. And if you paste an array formula in the formula cell, after the formula is pasted, select the formula cell, press F2 (Function Key), hold down the Ctrl+Shift keys together and then hit Enter. When an array formula is entered correctly, you will notice in the formula bar that the formula gets surrounded by the Curly Brackets { } and if you don't see the curly brackets in the formula bar, try again by following the steps mentioned above to re-enter the formula as an array formula.

Assuming that your data is in the range A2:B20 (row 1 being the headers), try these array formulas.

In D2 (To get an sorted unique list of Types)

Please Login or Register  to view this content.

and then copy down until you get blank cells.

In E2

Please Login or Register  to view this content.

and then copy across to I2 and down. ( or as per your need.)