Hi all,
I saw a post about adding weekend dates that used a cool TS Filler tool but I have a slightly different variation because there are multiple accounts in my data instead of just one set. How would I be able to generate the Sat and Sun dates keeping the same values (Account and Amount) of the previous Friday's data? Thanks.
Date Account Amount
2020-07-01 Bank of America 100
2020-07-01 Wells Fargo 200
2020-07-02 Bank of America 127
2020-07-02 Wells Fargo 228
2020-07-03 Bank of America 156
2020-07-03 Wells Fargo 183
2020-07-06 Bank of America 278
2020-07-06 Wells Fargo 123
2020-07-07 Bank of America 286
2020-07-07 Wells Fargo 178
2020-07-08 Bank of America 212
2020-07-08 Wells Fargo 186
2020-07-09 Bank of America 265
2020-07-09 Wells Fargo 175
2020-07-10 Bank of America 279
2020-07-10 Wells Fargo 132
2020-07-13 Bank of America 246
2020-07-13 Wells Fargo 179