Forum Discussion
change positions
Hello,
you can use Power Query to do that. Power Query is a free add-in from Microsoft for Excel 2010 and 2013 and built into Excel 2016 as Get and Transform.
Create a new query from a file, navigate to the CSV file and open it. Remove the columns you don't need, reorder the columns as you need them and save the query to the worksheet. Save the file as an Excel file.
Then use Save As to save the sheet with the query result as a CSV file.
When the original CSV file changes, you can open the saved Excel file, refresh the Power Query and save the query result as a CSV file again.
Hello,
you can use Power Query to do that. Power Query is a free add-in from Microsoft for Excel 2010 and 2013 and built into Excel 2016 as Get and Transform.
Create a new query from a file, navigate to the CSV file and open it. Remove the columns you don't need, reorder the columns as you need them and save the query to the worksheet. Save the file as an Excel file.
Then use Save As to save the sheet with the query result as a CSV file.
When the original CSV file changes, you can open the saved Excel file, refresh the Power Query and save the query result as a CSV file again.
And also, the problem I have is that the CSV source is not one file, is one everytime someone runs a function so there could be multiple CSV files, and I need to automate this so that no ones opens it from a folder manually.....