Hi,

I have the following table at my worksheet:

Each row contains only a text or a number.

A B C D
1 Hp Hp <- only one entry per row
2 Qt Qt
3 Kx Kx
4 Qt Qt
5 Hp Hp
6 Kx Kx
2500


May I know what formula to input at cell D1 and copy down to pick up the
data from each cell in column A to C as illustrated ?

Thanks

Low


--
A36B58K641