J
justforthis1
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
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