Excel Power Pivot Expert / Macro Expert
Budget: €8 – €30 EUR
Hello,
my client is downloading .csv reports from an external platform.
The platform is in English his computer German. So there needs to be some change of settings when reading .csv file (change to UTF 8) and some easy transformation of numbers for one column (divide by 100). Also want to show the sum for one column.
I need some kind of template or automation since my client downlaods the same file every month. Either a macro solution or power pivot. I used power pivot to transform the file manually but I am not sure if there can be some automation or generalisation.
!!!!IMPORTANT: start your application with the word "Power Pivot" to show you have read the description.
Thanks
my client is downloading .csv reports from an external platform.
The platform is in English his computer German. So there needs to be some change of settings when reading .csv file (change to UTF 8) and some easy transformation of numbers for one column (divide by 100). Also want to show the sum for one column.
I need some kind of template or automation since my client downlaods the same file every month. Either a macro solution or power pivot. I used power pivot to transform the file manually but I am not sure if there can be some automation or generalisation.
!!!!IMPORTANT: start your application with the word "Power Pivot" to show you have read the description.
Thanks