Group list by value at index 0

1

Hello

Im searching for a solution to group at list that contains mulptile itme by the value at index 0 at each list

Problem%20with%20grouping
Problem with grouping.png1712×824 94.5 KB

To be more precise i want to group the list by the first 3 numbers in the string ?

the end result i want i an export to excel that looks like this
Capture

im thinking something like this

image
image.png1576×563 73.3 KB

But it needs to group by the 3 first number in index 0

is someone able to point me in the right direction ? :slight_smile: thx in advance

2

Try String.Subtring to get the first 3 characters.

3

@Thom5567 Hope this helps.

Substring
Substring.png1336×606 36.3 KB

Substring%201
Accept as solution. If all looks good.

4

Thx Rajkumar_Nallusamy

Ill check if it works when i get back home

Thom5567