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.

Thx guys… I want to create rows with rectangles. All “A” rectangles in a row, All “B” rectangles in a row. So i want to split the list in A, B and in the future in C, D etc.