Hi, I have been out of town for awhile and did not check the forum. That is the way that I would like the to be split. Ideally, the file names would be in a sequential order to make it simple. As long as each column has a header, the file name does not matter. Yes, it will be repeated for every row in the original data. The row numbers change from file to file as well as the column numbers.

The solutions offered by Marshall and Kevbot did the trick. Thank you for your assistance.