Forum Discussion
insert space between date range
I have a row of information ( travel log ) over a set of dates downloaded from an app, how can I insert a space between the dates in a specific column ? see below I need a space between 18th and 19th...
If you're using Excel 365 and are open to using a formula:
dates = column with dates
=LET(
UniqueDates, UNIQUE(INT(dates)),
AddBlanks, LAMBDA(a, v,
LET(
filtered, FILTER(dates, INT(dates) = INT(v)),
r, ROWS(filtered) + 1,
resize, EXPAND(filtered, r, , ""),
VSTACK(a, resize)
)
),
REDUCE("Dates", UniqueDates, AddBlanks)
)