![]() ![]() This data had a column called Period and contained the numbers 1 to 12. 4 million rows of data loaded into my data model from a year’s worth of transactions in a 1.7 GB text file. So how do you do it? The Answer is PowerPivot! If you’ve ever checked (Press End then the down arrow key) Excel has just over 1 million rows, but if you start adding a formula or two to those rows then you will soon have issues. However, some do, and I recently needed to do this. Not many people need to bring 4 million rows of data into Excel. Free Online Financial Modelling Training.Acterys Budgeting & Forecasting Software.Solver Corporate Performance Management.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |