I am importing data into a spreadsheet. Each record has 6 to 11 fields. The data gets imported as one long list...so all date is in colum A. The first record in cells a1 to a11, then a space, then the second in a12 to a20, space...and so on. I want to transpose the records so the data goes across the colums (A through K). I know I can transpose it on record at a time using the Paste->transpose data command...but there are many records and this will take days. How can I create a macro to transpose the entire worksheet at once??