Remove Suffix from Date column and repeat rows based on condition

Question

Hi , I want to remove " ET" or "CT" from my column A to D i.e all the columns having date with a suffix. Also if the diff between "From Date " and "To Date" is more than 1 day then I want the rows to repeat for that many times..  For eg : If the difference is 7 days then that row should repeat for 7 times .

Sample file.xlsx

binu_acs · Accepted Answer

@AnanditaShankar One way of doing this with the Multi-Field formula

binu_acs · Accepted Answer

@AnanditaShankar use one more row generate tool to generate the expected result you mentioned above