Robert87
10-04-2016, 09:01 PM
Hey guys!
I´ve gotten alot of help on this forum before, and now I have come to yet another issue with a Excel function that I can´t seem to solve.
I´m making a cutting list for work, and I want the list to separate the data a bit more.
I´ll explain.
Amount
Length
Type 1
Cutting Info
Type 2
Label
2
2180,0
M3TR-1201
1 BRY-V:1741 / UB-V:119
372847
[1]-7 [1]-14
2
2080,0
M3TR-1201
372847
[1]-6 [1]-15
10
1980,0
M3TR-1201
1 BRY-V:1741 / UB-V:119
372847
[5]-6 [3]-7 [2]-9
110
1980,0
M3TR-1201
372847
[10]-1 [10]-2 [10]-3 [10]-4 [10]-5 [10]-6 [10]-7 [10]-8 [10]-9 [10]-10 [10}-11
20
1950,0
M3TR-1201
372847
[5]-4 [5]-5 [10]-6
Amount if the total amount of pieces of that length and type.
Length if the lenght of the piece that´s gonna be cut.
Type 1 is the drawing number that the piece is going to be cut after.
Cutting info is the measurements for cutting
Type 2 is another drawing number
And then we have Label. Here is my problem.
The number inside of the [] is an amount.
If we take the first row as an example.
[1]-7 [1]-14
That means that 1 piece is being labeled with "7" and 1 piece is being labeled with "14"
As you can see on the fourth row there can be alot of [] on the same line. I would think that the maximum I´ve ever seen is around 25 different labels on the same row.
What I want my Excel to be able to do is to take that list up there and change it to this:
Amount
Length
Type 1
Cutting Info
Type 2
Label
1
2080,0
M3TR-1201
1 BRY-V:1741 / UB-V:119
372847
[1]-7
1
2080,0
M3TR-1201
1 BRY-V:1741 / UB-V:119
372847
[1]-14
1
1980,0
M3TR-1201
372847
[1]-6
1
1980,0
M3TR-1201
372847
[1]-15
5
1980,0
M3TR-1201
1 BRY-V:1741 / UB-V:119
372847
[5]-6
3
1980,0
M3TR-1201
1 BRY-V:1741 / UB-V:119
372847
[3]-7
2
1980,0
M3TR-1201
1 BRY-V:1741 / UB-V:119
372847
[2]-9
10
1980,0
M3TR-1201
372847
[10]-1
10
1980,0
M3TR-1201
372847
[10]-2
10
1980,0
M3TR-1201
372847
[10]-3
10
1980,0
M3TR-1201
372847
[10]-4
10
1980,0
M3TR-1201
372847
[10]-5
10
1980,0
M3TR-1201
372847
[10]-6
10
1980,0
M3TR-1201
372847
[10]-7
10
1980,0
M3TR-1201
372847
[10]-8
10
1980,0
M3TR-1201
372847
[10]-9
10
1980,0
M3TR-1201
372847
[10]-10
10
1980,0
M3TR-1201
372847
[10]-11
5
1980,0
M3TR-1201
372847
[5]-4
5
1980,0
M3TR-1201
372847
[5]-5
10
1980,0
M3TR-1201
372847
[10]-6
I need it to separate the labels into a row each.
Is this doable?
Can someone help me with this?
Would be greatly appreciated.
17261
I´ve attached a excel file with the data above in it.
I´ve gotten alot of help on this forum before, and now I have come to yet another issue with a Excel function that I can´t seem to solve.
I´m making a cutting list for work, and I want the list to separate the data a bit more.
I´ll explain.
Amount
Length
Type 1
Cutting Info
Type 2
Label
2
2180,0
M3TR-1201
1 BRY-V:1741 / UB-V:119
372847
[1]-7 [1]-14
2
2080,0
M3TR-1201
372847
[1]-6 [1]-15
10
1980,0
M3TR-1201
1 BRY-V:1741 / UB-V:119
372847
[5]-6 [3]-7 [2]-9
110
1980,0
M3TR-1201
372847
[10]-1 [10]-2 [10]-3 [10]-4 [10]-5 [10]-6 [10]-7 [10]-8 [10]-9 [10]-10 [10}-11
20
1950,0
M3TR-1201
372847
[5]-4 [5]-5 [10]-6
Amount if the total amount of pieces of that length and type.
Length if the lenght of the piece that´s gonna be cut.
Type 1 is the drawing number that the piece is going to be cut after.
Cutting info is the measurements for cutting
Type 2 is another drawing number
And then we have Label. Here is my problem.
The number inside of the [] is an amount.
If we take the first row as an example.
[1]-7 [1]-14
That means that 1 piece is being labeled with "7" and 1 piece is being labeled with "14"
As you can see on the fourth row there can be alot of [] on the same line. I would think that the maximum I´ve ever seen is around 25 different labels on the same row.
What I want my Excel to be able to do is to take that list up there and change it to this:
Amount
Length
Type 1
Cutting Info
Type 2
Label
1
2080,0
M3TR-1201
1 BRY-V:1741 / UB-V:119
372847
[1]-7
1
2080,0
M3TR-1201
1 BRY-V:1741 / UB-V:119
372847
[1]-14
1
1980,0
M3TR-1201
372847
[1]-6
1
1980,0
M3TR-1201
372847
[1]-15
5
1980,0
M3TR-1201
1 BRY-V:1741 / UB-V:119
372847
[5]-6
3
1980,0
M3TR-1201
1 BRY-V:1741 / UB-V:119
372847
[3]-7
2
1980,0
M3TR-1201
1 BRY-V:1741 / UB-V:119
372847
[2]-9
10
1980,0
M3TR-1201
372847
[10]-1
10
1980,0
M3TR-1201
372847
[10]-2
10
1980,0
M3TR-1201
372847
[10]-3
10
1980,0
M3TR-1201
372847
[10]-4
10
1980,0
M3TR-1201
372847
[10]-5
10
1980,0
M3TR-1201
372847
[10]-6
10
1980,0
M3TR-1201
372847
[10]-7
10
1980,0
M3TR-1201
372847
[10]-8
10
1980,0
M3TR-1201
372847
[10]-9
10
1980,0
M3TR-1201
372847
[10]-10
10
1980,0
M3TR-1201
372847
[10]-11
5
1980,0
M3TR-1201
372847
[5]-4
5
1980,0
M3TR-1201
372847
[5]-5
10
1980,0
M3TR-1201
372847
[10]-6
I need it to separate the labels into a row each.
Is this doable?
Can someone help me with this?
Would be greatly appreciated.
17261
I´ve attached a excel file with the data above in it.