Excel 2002??? Is that a release version of Excel 365? If so, please update your profile.
Your query, as it stands, is utterly insufficient. You will need to provide some sample data to illustrate what you want. Attach your sample workbook here, please.