Slicing the RowIndex fails because of sub-list

[Pch]

@Christiaan_Huizer : You’re welcome !

As I also tend to overcomplicate things , I’ll admit that it took me a while to find the simple solution !

As for List() and ListCombine() @BenLee mentioned this in another topic

@BenLee

List() can create (One, Two, [Three, Four, Five]) where [Three, Four, Five] is considered 1 item.
ListCombine() flattens it and makes this (One, Two, Three, Four, Five) and is considered 5 items.

Which I think, is the main difference between the two .

As for knowing which one is best, I think it really depends on the use .

But, I’ve created few examples using List() and ListCombine() in my sample below . It might give you a better idea on how they both work .