The P04_12.txt file is a text file with data about uninsured people in each state for the years 20032007. Use Power Query to import this data into an Excel table (not a Data Model) and sort in increasing order of Year. As you will see, this is a wide table, with four columns for every state and only five rows, and it isnt very useful for analysis. It would be better to have a narrow, tall table with columns for Year, State, and the four uninsured numbers/percentages reported. Do whatever it takes to rearrange the data this way. Then create a pivot table where you can see any of the numbers/percentages across years for any selected state. (Hint: You could do this with a lot of cutting and pasting. However, a better way is to use Excels INDEX function with clever row and column indexes. For example, the number of uninsured females in Alaska in 2004 can be found with =INDEX(range,2,5), where range is the range of the imported numbers/percentages.) What was the total number of uninsured males for the states of California and Florida in 2007?

	2007
California
Florida