Difficult scenerio, move columns to a new line

I have to move items that are in a line, across columns, to be moved to their own line.  I have 3000 records to do this with.   Basically lets say you have a basket (column A1) in that basket is ch...