I have a worksheet that has multiple labor categories listed on different
lines. On another worksheet I want to pull each labor category only once and
put them each on a different line. Please see example below. Is there a way
to do this in excel and if so how?
Thanks,
Jana

WORKSHEET A
A
1 S1
2 T3
3 T4
4 S1
5 T3
6 S2

I want the formulas in worksheet B so they will deliver the following data -
don't need them in any certain order, just need each to only list once on a
different line.
WORKSHEET B
A
1 S1
2 S2
3 T3
4 T4