Mr_Ragweed
Board Regular
- Joined
- Dec 10, 2012
- Messages
- 74
Hello, i think this should be simple but......i'm not great at this.
I have a single worksheet that looks like the following:
<tbody>
</tbody>
I need to sort it based on column A and i ned the number rating to stay to the right of the name. As you can see the columns will be af varying length and some may have no data at all. The width of the sheet is fixed and ends with column X. The length of column A will be dynamic based on which location is running the information.
What it needs to lok like is this:
<tbody>
</tbody>
Thanks in advance, and thanks again to those who have helped me before!
I have a single worksheet that looks like the following:
Customer | MasMas | MASMas# | MASChm | MASChm# | MASDry | MASDry# | |||
tom | bob | 2 | bob | 3 | jimmy | 2 | |||
bob | bill | 1 | bill | 1 | kevin | 2 | |||
bill | jimmy | 3 | kevin | 5 | steve | 3 | |||
kevin | steve | 2 | tom | 1 | |||||
steve | |||||||||
jimmy | |||||||||
<tbody>
</tbody>
I need to sort it based on column A and i ned the number rating to stay to the right of the name. As you can see the columns will be af varying length and some may have no data at all. The width of the sheet is fixed and ends with column X. The length of column A will be dynamic based on which location is running the information.
What it needs to lok like is this:
Customer | MasMas | MASMas# | MASChm | MASChm# | MASDry | MASDry# | |||
tom | | | | | tom | 1 | |||
bob | bob | 2 | bob | 3 | |||||
bill | bill | 1 | bill | 1 | | | |||
kevin | | | kevin | 5 | kevin | 2 | |||
steve | steve | 2 | steve | 3 | |||||
jimmy | jimmy | 3 | jimmy | 2 | |||||
<tbody>
</tbody>
Thanks in advance, and thanks again to those who have helped me before!