Forum Discussion
Remove-Manipulate Quicken Data for Reporting
After bringing CSV into Excel I would like to convert to pivot table, but need to insert week ending data to each significant row (green) and remove date row without financial data, blank and total rows (yellow)
In general it's job for Power Query - to import and transform csv file. Csv doesn't keep formatting, it's not clear what the significant row is. Perhaps in addition to source csv you may share xlsx file marking what shall be deleted. Or with desired output data.
3 Replies
Thank you, I'll study up on PQ - My thanks
In general it's job for Power Query - to import and transform csv file. Csv doesn't keep formatting, it's not clear what the significant row is. Perhaps in addition to source csv you may share xlsx file marking what shall be deleted. Or with desired output data.
Thank you
