Forum Discussion
Repeat data multiple times
Hello All - I have a business scenario. Each month, I get a EE list file from HR. I have to format that data based on my excel file and paste the data in stipulated columns. Since the file is used fo...
Another possible solution could be Power Query with From Folder connector in which you keep monthly files. Once done, next times only to add another file to the folder and press Refresh All.
It's hard to be more concrete without knowledge of how exactly data is structured in input and output files.
