allow; (3) click on “Next”; (4) click on “Finish” – If this doesn’t work then repeat initial steps 1-4 (i.e., through “Text to Columns”) and then change from “Fixed Width” to “Delimited” and follow as immediately above. Also, you might need to copy (i.e., highlight) what you want to move, click on “copy,” then “paste special” and click on “values.” I’ve been able to move stuff from a downloaded Excel file into another Excel file by this method.
: If you keep the “control” key down, you can highlight non-consecutive rows or columns. Unfortunately, when you then try the copy or cut option, it won’t work. So, you need an alternative strategy. Try the following: (1) duplicate the entire file so you won’t harm the original; (2) take the unit you trying to “stack” by (e.g., state or year) and copy the names of the various units so they are on both the left and right side of the spreadsheet (i.e., it is much easier to know what unit you’re on if the information is on both sides of the spreadsheet); (3) highlight all the information between consecutive observations on the unit (e.g., if you have data for the 50 state by year – observation 1 is Alabama in year 1920 and observation 2 is Alaska in 1920 and want to covert this so that observation 2 is Alabama in 1921 then highlight all rows between Alabama in 1921 and Alabama in 1922) and then right click on “copy” and then paste (e.g., using “control v”) into the new document.
– (1) highlight the row
or column the symbol you want to remove is in; (2) click on “Format”; (3) click on “Cells”; (4) highlight “number” (to covert to just numbers); (5) click on “Okay”
: (1) select all the cells that have information; (2) go to
the “Edit” menu; (3) within this menu go to “Clear”; (4) from the list select “Formats” (the cells should now be broken into two – now we will delete the blank cells); (5) go to the “Edit” menu; (6) within this menu select “Go To”; (7) on the “Go To” menu click “Special”; (8) on the list select “Blanks”; (9) press “OK”; (10) go to the “Edit” menu; (11) within this menu select “Delete”; (12) in the delete box select “Shift cells up”; (13) press “OK”
: Let us say that you are working with annual time series data and
have scores at decade wide intervals (e.g., census figures every 10 years). If you want to average the change over the intervening years, precede as follows: (1) find the amount (or rate) of change over the time interval you are interested in (e.g., if there is a 2 point change over 10 years, this would be .2 of a point per year); (2) In the first cell in which