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. ...
This sounds doable with Get & Transform aka Power Query. Could you:
- Upload & share (ie with OneDrive or any other file sharing service) a representative sample CSV with say 4 or 5 PO#
- List precisely the columns you want to keep
Link is linked. Thanks for the reply!! I would like to retain:
Columns A, C, F, L, N, QThat'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.
