Information on four different heads is available in a single column in different rows which needs to be transposed to a single row in different columns. About a thousand records are now in about 5000 rows, which need to be rearranged in a single row each. Unwanted data needs to be deleted. Basically, one record will require 1/2 cells of copy/paste and 2/3 cells of delete.