ok ive been trying to make excel do this, but im stumped...

basically i have a sheet that has

group tag description part #
#1 1 misc ABCD123ABC
#1 2 misc DEF12XYZ
#1 3 misc 123ABC

#2 4 misc LMNOP123ABC
#2 5 misc XYZ12ABC
#2 6 misc 345ABC

#3 7 misc ABCD123ABC
#3 8 misc DEF12XYZ
#3 9 misc 123ABC

#4 10 misc HJKL123ABC
#4 11 misc XYZ12XYZ
#4 12 misc 789ABC

#5 13 misc LMNOP123ABC
#5 14 misc XYZ12ABC
#5 15 misc 345ABC

i want each group to behave like a single row instead of 3
i want to be able to sort by part # and have all the groups that have
the same part numbers with each other...

for instance...

group tag description part #
#1 1 misc ABCD123ABC
#1 2 misc DEF12XYZ
#1 3 misc 123ABC

#3 7 misc ABCD123ABC
#3 8 misc DEF12XYZ
#3 9 misc 123ABC

#2 4 misc LMNOP123ABC
#2 5 misc XYZ12ABC
#2 6 misc 345ABC

#5 13 misc LMNOP123ABC
#5 14 misc XYZ12ABC
#5 15 misc 345ABC

#4 10 misc HJKL123ABC
#4 11 misc XYZ12XYZ
#4 12 misc 789ABC

if anyone can help me with this that would be great...

thanks

Assuming your headings are in row 1 and the data is in columns A - D, enter
the following in E2 and copy down through all rows of data (including the
blank rows):

=IF(OR(A2=A1,ISBLANK(A2)),E1,D2&A2)

If you want to eliminate the blank rows, use:

=IF(A2=A1,E1,D2&A2)

Then, sort data by column E.

Hope this helps,

Hutch

"justforthis1" wrote:

> ok ive been trying to make excel do this, but im stumped...
>
> basically i have a sheet that has
>
> group tag description part #
> #1 1 misc ABCD123ABC
> #1 2 misc DEF12XYZ
> #1 3 misc 123ABC
>
> #2 4 misc LMNOP123ABC
> #2 5 misc XYZ12ABC
> #2 6 misc 345ABC
>
> #3 7 misc ABCD123ABC
> #3 8 misc DEF12XYZ
> #3 9 misc 123ABC
>
> #4 10 misc HJKL123ABC
> #4 11 misc XYZ12XYZ
> #4 12 misc 789ABC
>
> #5 13 misc LMNOP123ABC
> #5 14 misc XYZ12ABC
> #5 15 misc 345ABC
>
> i want each group to behave like a single row instead of 3
> i want to be able to sort by part # and have all the groups that have
> the same part numbers with each other...
>
> for instance...
>
> group tag description part #
> #1 1 misc ABCD123ABC
> #1 2 misc DEF12XYZ
> #1 3 misc 123ABC
>
> #3 7 misc ABCD123ABC
> #3 8 misc DEF12XYZ
> #3 9 misc 123ABC
>
> #2 4 misc LMNOP123ABC
> #2 5 misc XYZ12ABC
> #2 6 misc 345ABC
>
> #5 13 misc LMNOP123ABC
> #5 14 misc XYZ12ABC
> #5 15 misc 345ABC
>
> #4 10 misc HJKL123ABC
> #4 11 misc XYZ12XYZ
> #4 12 misc 789ABC
>
> if anyone can help me with this that would be great...
>
> thanks
>
>