Forum Discussion
PieGuy
Dec 16, 2022Copper Contributor
Excel Macro or Pivot Table Help
I have a csv file, that i need to repeat certain cells in certain columns, and then also delete empty rows AND certain cells that would move that data up, so every row contains data with no blanks. ...
PieGuy
Dec 19, 2022Copper Contributor
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.
Lorenzo
Dec 19, 2022Silver Contributor
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
- PieGuyDec 19, 2022Copper ContributorHi 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.
- LorenzoDec 20, 2022Silver Contributor
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
- PieGuyDec 21, 2022Copper Contributor
Lorenzo WOW! Thanks so much. It looks amazing. i was having a little trouble replicating it though.
- I exporting a new source file,
- saved file to my hard drive
- copied that file pathname to Param / B1
- went back to Output Query and right clicked and refreshed and nothing happened. any suggestions? Thanks again for all your help. the final product is perfect.