Filter rows

Hello everyone,   Is there a way to assign numbers from one cell into another cell? Example, if I place 1-10 in once cell but will like to filter the data from it into columns B-G using the letter ...