Convert single colum/multiple rows to multiple colums.

[Jeff]

Sorry if double posted. Tried to sign in?

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. Any chance this can be done. It's quite large. 51,793 rows.

TIA

Jeff

Col 1 Col 2 Col 3
Name Date Lenny Kravitz - 2000 - Greatest Hits


-- Table: {2}
{
"music"
"Name",
"06/04/2008",
"Lenny Kravitz - 2000 - Greatest Hits",
},
--Table: {3}
etc.
etc.

 

[ShaneDevenshire]

Hi Jeff,

the answer is yes. You would have to program it in VBA and for that you
would need to post all the details to this list.
I would make it a new post.