Repeat each Item in the List given Variable number of Times
We have used SCAN, XLOOKUP, SEQUENCE Functions for the purpose of solving this task.
Input -- Jan (3), Feb (2), Mar (4)
Output -- Jan, Jan, Jan, Feb, Feb, Mar, Mar, Mar, Mar
We have used SCAN, XLOOKUP, SEQUENCE Functions for the purpose of solving this task.
Input -- Jan (3), Feb (2), Mar (4)
Output -- Jan, Jan, Jan, Feb, Feb, Mar, Mar, Mar, Mar