Group list by value at index 0



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

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

im thinking something like this

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


Try String.Subtring to get the first 3 characters.


@Thom5567 Hope this helps.

Accept as solution. If all looks good.


Thx Rajkumar_Nallusamy

Ill check if it works when i get back home