I have an excel spreadsheet with two columns. In the first cell is a text and in the second cell of the same row is a number.
A I 10
A I 20
B I 20
B I 30
My goal is to take the values in the first column and to use the text to split the list. Because the amount of values will grow, i can not split by index.
With the number i will then create rectangles.
Do you have any recommendation how to do that?