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.
Labels.xlsx

I´ve attached a excel file with the data above in it.