Spreadsheet: 102005d1300075945-index-match-to-reformat-data-reorgdata-w1-wf-lr-lc-count-rng-staci-ef768143-sdg13
Sheet: Instructions

Date | Last Name | First Name | Quantity | Hours | AVG. |  |  | Today, 09:13 PM
2011-03-01 00:00:00 | Olive | Annabel | 240 | 8 | 30 |  |  | ReorgData w1 wF LR LC Count rng - Staci - EF768143 - SDG13.xls
2011-03-01 00:00:00 | [NAME] | Asher | 195 | 5 | 39 |  |  | Registered User   Join Date: 05 Mar 2011
2011-03-01 00:00:00 | [NAME] | Atticus | 266 | 8 | 33.25 |  |  | Location: Savannah, GA
2011-03-01 00:00:00 | Otis | August | 197 | 8 | 24.625 |  |  | MS Office Version:Excel 2003 (work), 2010 (home)
2011-03-01 00:00:00 | [NAME] | Butch | 275 | 7.5 | 36.66666666666666 |  |  | Posts: 7
2011-03-01 00:00:00 | Piper | Clementine | 241 | 8 | 30.125 |  |  | index Match to reformat data
2011-03-01 00:00:00 | Ray | Dashiell | 285 | 7.5 | 38 |  |  | [NAME]
2011-03-01 00:00:00 | Roman | [NAME] | 257 | 7.75 | 33.16129032258065 |  |  | I have several trackers that production employees fill out daily,
2011-03-01 00:00:00 | Romy | [NAME] |  | 8 |  |  |  | that are in an ugly format for data anaylsis, but is convenient for their daily use.
2011-03-01 00:00:00 | Roscoe | Dixie | 180 | 8 | 22.5 |  |  | I was wondering if someone could help me figure out a way to get the information into the format that I would like.
2011-03-01 00:00:00 | Ruby | Duke | 257 | 7.75 | 33.16129032258065 |  |  | I would like the data to show in columns:
2011-03-01 00:00:00 | Rufus | [NAME] | 235 | 8 | 29.375 |  |  | Dates
2011-03-01 00:00:00 | Sadie | Ella | 250 | 8 | 31.25 |  |  | Last Name
2011-03-01 00:00:00 | [NAME] | Josiah | 155 | 4 | 38.75 |  |  | First Name
2011-03-01 00:00:00 | Stellan | [NAME] | 258 | 7.5 | 34.4 |  |  | Quantity
2011-03-01 00:00:00 | [NAME] | Silas | 195 | 7.5 | 26 |  |  | Hours
2011-03-01 00:00:00 | Talullah | Stella | 264 | 7.5 | 35.2 |  |  | Avg
2011-03-01 00:00:00 | [NAME] | Violet | 251 | 7.5 | 33.46666666666667 |  |  | I am going to show the workbook, exactly as the Tracker is formatted,
2011-03-02 00:00:00 | Olive | Annabel | 231 | 7 | 33 |  |  | then there is an example of the format that I would like to get all the data.
2011-03-02 00:00:00 | [NAME] | Asher | 151 | 3.75 | 40.26666666666667 |  |  | I was thinking, maybe I could have this "Final Format" sheet in each workbook, but I am not sure.
2011-03-02 00:00:00 | [NAME] | Atticus | 231 | 7 | 33 |  |  | Any ideas would be appreciated.
2011-03-02 00:00:00 | Otis | August | 191 | 7 | 27.28571428571428 |  |  | Thanks,
2011-03-02 00:00:00 | [NAME] | Butch | 221 | 6.5 | 34 |  |  | Staci
2011-03-02 00:00:00 | Piper | Clementine | 222 | 7 | 31.71428571428572
2011-03-02 00:00:00 | Ray | Dashiell | 231 | 7 | 33 |  |  | Date
2011-03-02 00:00:00 | Roman | [NAME] | 225 | 6.5 | 34.61538461538461 |  |  | Last Name
2011-03-02 00:00:00 | Romy | [NAME] | 241 | 7 | 34.42857142857143 |  |  | First Name
2011-03-02 00:00:00 | Roscoe | Dixie | 161 | 7 | 23 |  |  | Quantity
2011-03-02 00:00:00 | Ruby | Duke | 226 | 7 | 32.28571428571428 |  |  | Hours
2011-03-02 00:00:00 | Rufus | [NAME] | 229 | 7 | 32.71428571428572 |  |  | AVG.
2011-03-02 00:00:00 | Sadie | Ella | 245 | 7 | 35
2011-03-02 00:00:00 | [NAME] | Josiah | 289 | 7 | 41.28571428571428
2011-03-02 00:00:00 | Stellan | [NAME] | 213 | 5.5 | 38.72727272727273
2011-03-02 00:00:00 | [NAME] | Silas | 189 | 5.5 | 34.36363636363637
2011-03-02 00:00:00 | Talullah | Stella | 200 | 5 | 40
2011-03-02 00:00:00 | [NAME] | Violet | 241 | 7.25 | 33.24137931034483