I would like to ask if someone can assist with the following:
I would like to combine two lists (Red & Blue) based on a third list (Yellow) - all lists have the same size - as shown in the following screenshot:
In more detail i have a list of 8760 hours (Highlighted in Yellow) where each hour has a 0 or 1 value.
I would like to combine the first two lists into one based on the 0 and 1 values. For every 0 value i need to get values from one list and for each 1 values get results from the other list. Is that possible?