Hi Katherine

Insert a blank row above your data, which is assumed to be in columns A:C
In G1 Type Staff, in H1 type Cellular No., in I1 type Office No.
In G2
=INDEX($A$1:$C$100,(ROW()-1)*2,1)
In H2
=INDEX($A$1:$C$100,(ROW()-1)*2,3)
In I2
=INDEX($A$1:$C$100,((ROW()-1)*2)+1,3)

Amend Range to whatever value above 100 contains all of your data.
Now, copy F2:I2 down the page as far as required.

Copy columns F:IPaste SpecialValues to change from formulae to the
data you require.
--
Regards
Roger Govier

Katherine wrote:
Hi - am trying to change rows to columns for similar records. How do I do that?
e.g.

Staff A Cellular No. XXXXX
Staff A Office No. XXXX
Staff B Cellular No. XXXXX
Staff B Office No. XXXXX

Wld like for it be in the following row
Staff Cellular No Office No
A XXXXX XXXXX
B XXXXX XXXXXX

Do advise. Thanks.