In this Test Google Sheet I have several columns that may or may not contain dates. I have used a =small(A2:E2, 1)
to provide me with the smallest date for a row... but I want to dynamically fill in the data down the column for every row that has values in it.
The data in my real-world example is being pulled in by a query and could easily update and include additional rows of data. I tried using Arrayformula and the following formula =Arrayformula(small(A2:E, 1))
but as expected small is looking though that whole array of columns and rows rather than just a single row. I need to know if there is a simple way to dynamically replicate the individual row down through any row that contains data? Please help!
try:
=ARRAYFORMULA(QUERY(TRANSPOSE(QUERY(TRANSPOSE(A2:F),
"select "&TEXTJOIN(",", 1,
"min(Col"&ROW(A2:A)-ROW(A2)+1&")")&"")),
"select Col2"))