A large spreadsheet consisting of four years of economic data for 14 countries needs to be formatted and organized. Some cell dates are formatted as txt and need to be properly formatted into dates for comparison and graphing. Also, some cells are formatted as txt (example 100k) that need to be formatted into numbers, again for comparison and graphing.
Ultimately I want to compare economic data across dates, countries and subsection (like in the first workbook) and the spreadsheet must have capacity to grow and change as data is added and comparison across different data time series. Graphing the data will help.