Process imported csv data - Classification

Use this forum for any general discussion and questions about Excel
Miguel-san
Posts: 2
Joined: Thu Mar 21, 2019 8:42 am

Process imported csv data - Classification

Postby Miguel-san » Sun Oct 13, 2019 8:05 am

Hello all,
I need to import external csv data files into an excel table. Then, I need to classify manually the data so I create a new column for it.

The problem is that every time I refresh the query to get new data, the rows are moved according to the new csv file data however the rows of the column I've created manually remains in the same order, hence the classification is ruined. The rows of the column I created do not match the rows of the query data.

For example, if I want to import my bank statements and then I want
to classify each of the entrances in topics like Food, Travel, etc. every-time I refresh the query to get up to date data statements the classification I made manually is ruined and no longer meaningful.

Could you advice how I should be doing such things to avoid this problem?

Thank you very much
Kind regards

Return to “Excel”

Who is online

Users browsing this forum: No registered users and 1 guest