Unique list from Row

Hello,

Could you please help me to get the unique list of values from a row, say F7:XFD7 and get that as a list in a column?

for example, if the data of F7 to J7 is

A,1,A,2,3

then from C2 to C7, it should look like

A
1
2
3

Thanks in advance

two simple steps w/o any formulas. Highlight the entire row, hit copy, put your cursor where you want the values, hit paste special values and transpose. Then keeping it highlighted, use the remove duplicates function.

EDIT: click on cell F7 and hold down shift and control and hit the right arrow to get the whole row. Then go to where you want the column and follow the rest above.

Data Range

	B	C	D	E	F
2	a	1	a	2	3

Data Range

	A
1	Formula Result
2	a
3	1
4	2
5	3
6
7

Array Formula Requires CTRL+SHIFT+ENTER

	A
2	=IFERROR(INDEX($B$2:$F$2,MATCH(0,COUNTIF($A$1:A1,$B$2:$F$2),0)),"")

Drag the formula down

@Sixthsense: Your formula worked perfectly.. thanks

@Sambo Kid: I didnt want to do that manually... there are some other calcualtions also involved and wanted to create a dynamic table. This request was a part of that Thanks for your help