Hi Tom, Thanks for reply. All the clients in the file, the flat file is less that 50,000 records currently in excel. Annual periods. This is what my data looks like: ID 08_31_2012 09_30_2012 10_31_2012 11_30_2012 12_31_2012 01_31_2013 02_28_2013 03_31_2013 04_30_2013 05_31_2013 06_30_2013 07_31_2013 410764 358 317 327 167 167 379 336 349 363 369 327 348 89254 303 261 303 98 98 279 227 272 275 274 291 317 65320 233 211 234 101 101 280 250 264 267 304 263 302 163328 218 188 227 98 98 249 230 227 251 246 238 277 36919 174 198 243 80 80 218 203 210 236 211 197 232 28341 78 159 207 61 61 177 171 183 191 179 180 204 448691 32 32 56 60 83 179 192 Thanks! Seth
... View more