Hi,
I have the following sample sheet:
GROUP PART# 20040923 20050301 20050404 20050512 20050527
ZY1 WX34 0.0247 0.0252 0.0252
ZY1 WZ45 0.0247 0.0252 0.0252
XY1 ZZ01 0.25 0.35
0.45
XY1 ZZ03 0.25 0.35
0.45
ABC AB05 0.25 0.35 0.45
ABC AB07 0.25 0.35 0.45

What I would like to get is the following:
GROUP PART# 20040923 20050301 20050404 20050512 20050527
ZY1 WX34 0.0247 0.0252 0.0252
XY1 ZZ01 0.25 0.35 0.45
ABC AB05 0.25 0.35 0.45

Basically, would like to get just the first item of each GROUP and copy the
whole row to another sheet

can this be done?

Please advise any help/feedback would appreciate it.

Thanks,

juan