• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

reducing rows in a .txt file when importing to excel

P0lar

Member
I have a pipe delimited .txt file export from another system which is likely to run close to 1 million rows when in full use, so importing to excel is risky and likely to slow the calculations etc. Each line shows how long a person spent on an activity on a given day, and there are about a dozen possible activities. I only need to know the total time for all activities for a person for a week which would reduce the number of rows in excel considerably. I can code something to compress the list once it's in a sheet but was wondering if there was a way to do this before the data reaches the sheet so that there's not a risk of exceeding the maximum number of sheet rows?
 
P0lar


You should have a look at using Power Pivot

It doesn't matter how many rows there are (well within very large limits)


Search for it in the Google Custom Search box at the top right

Chandoo has written a few posts about it
 
Back
Top