Forum Discussion

rhockman's avatar
rhockman
Brass Contributor
May 12, 2023
Solved

Power Query

Is there a way to extract these dates from one cell and add new rows for each date, easily in power query or another method?    
excel
  • Lorenzo's avatar
    Lorenzo
    May 12, 2023

    rhockman 

    another 365

    =LET(
  clean,  SUBSTITUTE(SUBSTITUTE(Table1[Date],"*","")," ",""),
  concat, LAMBDA(n,d, n & "," & SUBSTITUTE(d,",",";" & n & ",")),
  VSTACK(
    Table1[#Headers],
    TEXTSPLIT(TEXTJOIN(";",,MAP(Table1[Name],clean,concat)),",",";")
  )
)

Resources