Forum Discussion
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. ...
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
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....went back to Output Query and right clicked and refreshed and nothing happened. any suggestions?
Nope 😞
Within Excel, go to Data (tab) > Queries & Connections (a pane opens on the right side of the screen)
#1 Do you see a triangle next to QueryOutput?
#2 If you see a triangle:
- Double-click on QueryOutput (the Power Query Editor opens)
- Click on the last APPLIED STEPS (on the right side of the screen)
What is the exact error message?
