Forum Discussion
Excel Macro or Pivot Table Help
This sounds doable with Get & Transform aka Power Query. Could you:
- Upload & share (ie https://support.microsoft.com/en-us/office/share-onedrive-files-and-folders-9fcc2f7d-de0c-4cec-93b0-a82024800c07 or any other file sharing service) a representative sample CSV with say 4 or 5 PO#
- List precisely the columns you want to keep
Lorenzo https://piecommission-my.sharepoint.com/:x:/p/pat/EfbjayAN6ylOqIOxR_X-6bUBwbyY_B7b6xANIcgagIcXRg?e=arO5F8
Link is linked. Thanks for the reply!! I would like to retain:
Columns A, C, F, L, N, Q
That's it!
Thanks in advance for any assistance.
The file you shared is not a CSV file but an Excel file with a .csv extension
Please clarify what your actual source file type is and re-share the actual file - Thanks
- Hi there - that was the actual file. sorry, i refer to excel files with csv extensions as csv files! the output file is, in fact, an excel file with a csv extension.
Hi PieGuy
i refer to excel files with csv extensions as csv files! the output file is, in fact, an excel file with a csv extension Very confusing. Not my call though...
I assumed you would have to do the same thing on a regular basis...
- Download the attached file
- Go to sheet Param
- In B1 enter the full path to your non-csv file
- Switch to sheet QueryOutput
- Right-click in the blue table > Refresh