cross posting
it is a ARRAY formula (STRG + SHIFT + ENTER). copy it and drag it down =IFERROR(INDIRECT("A"&SMALL(IF(B:B="";"";ROW(A:A));ROW(A2)));"")
I used your example files and may be the info there was too simple. in your latest attachment I can only see a result without source (sample files). ...
Hi Jacek, ad 6) as long as your tables look the same you can directly use the column names because they will not change (I assume) and therefore al...
you missed a bracket 🙂 Source = #table( type table [Dates=date],{{List.Dates(#date(2019, 1, 1), Duration.Days(DateTime.Date(DateTime.FixedLo...
Hi Vivian, why are you not using let #"Start Date" = #date(2019, 1, 1), Source = List.Dates(#"Start Date", Duration.Days(DateTime.Date...
Hi Jacek, only a small modification is required. Then you can use it as a function (as long neither worksheet name and number of columns are changi...
You can find my solution in the attachment. I used functions to - read your parameter "File Path" - read Table1 on sheet TableToMerge of ea...