I am sorry but it is not quite clear what you want. At first glance it appears that you want the values in Column A to go in the last row of column F which I would think would be as simple as =A2 and then autofill it down. but other than that I dont quite understand what you are looking for. Could you post a sample worksheet with the desired result?

Thanks