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

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

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.


Accept as solution. If all looks good.


#4

Thx Rajkumar_Nallusamy

Ill check if it works when i get back home

Thom5567