Combine values from different lists into one list


#1

Hi,

How can I combine the values in different lists into one list in the same order the values has been found? If there is no value in one list it needs to check if there is a value in a other list (see printscreen below). In that same order I want the list. So it would be:
0: B
1: C
2: C
3: C
4: B
5: A

Thanks!


#2

Something like this maybe?


#3

Hi,

@Jonathan.Olesen, i think you could use String.Concat right after List.Transpose :slight_smile:


#4

Thanks @mellouze!! That will do the trick!

@Jonathan.Olesen: Somehow that didn’t worked for me…


#5

Well… Because you’re not doing as I am? :stuck_out_tongue:

In any case the method by @mellouze is better :slight_smile:


#6

Sorry about that! :slight_smile: It worked also! :wink:


#7

@Danny You could also avoid Transpose


#8

I agree, and thought about that as well, but that prescribes that you have the same number of lists every time :slight_smile: