Data Conversion and Reformatting

It is often useful to reformat data in an Excel worksheet, to sort, remove empty cells, extract some columns, etc. We will show how to accomplish these types of operations in Excel.

Also when data from Excel is to be imported for use in standard statistical packages such as SAS and SPSS, it is often necessary to change the format of the data. Similarly when data from one of these standard packages is used by Excel, it may be necessary to reformat the data. We will also show how to accomplish these conversions using Excel.


2 Responses to Data Conversion and Reformatting

  1. Leo says:

    I notice that all the topic hyperlinks, except the last one, are not working.

Leave a Reply

Your email address will not be published. Required fields are marked *