I have a table which I would like to make more dynamic based on values in two ranges.

• I have a first table - DATE - (one column containing 1st January 2021 - 31st December 2022)
• I have a second table - UUID - (one column containing the UUID)

Is there a way to display Each date individually for each UUID there is for each day like in the picture with a single formula?

Thanks alot!

CodePudding user response：

try:

=INDEX(SPLIT(FLATTEN(FILTER(DST!A4:A, DST!A4:A<>"")&"×"&
 TRANSPOSE(FILTER(MODTANEWBIE_PER!E3:E, MODTANEWBIE_PER!E3:E<>""))), "×"))

and for count:

=ARRAYFORMULA(IFNA(VLOOKUP(A4:A&B4:B, 
 {ATT_ARCHIVE!A4:A&ATT_ARCHIVE!B3, ATT_ARCHIVE!B4:B;
  ATT_ARCHIVE!A4:A&ATT_ARCHIVE!C3, ATT_ARCHIVE!C4:C}, 2, 0)))