Convert single colum/multiple rows to multiple colums.

[Jeff]

Hi,

I have a .dat file when opened with Excel it has 1 column and 7 rows per
entry. I would like to delete some rows and convert the rest to something
like I have below. Any chance this can be done? It's quite large. 51,793
rows.

TIA

Jeff

Col 1 Col 2 Col 3
User Name Date Artist

users name 06/04/2008 Lenny Kravitz -
2000 - Greatest Hits
users name 02/03/2007 Cold War Kids -
2007 - Robbers & Cowards


-- Table: {1}
{
"music"
"users name",
"06/04/2008",
"Lenny Kravitz - 2000 - Greatest Hits",
},

-- Table: {2}
{
"music",
"users name",
"02/03/2007",
"Cold War Kids - 2007 - Robbers & Cowards",
},

etc
etc