Convert single colum/multiple rows to multiple colums.

Been working slowly on a non-macro solution while others have posted, but I'll offer this anyway.
Regards
Mike

Originally Posted by Mikeopolo

Been working slowly on a non-macro solution while others have posted, but I'll offer this anyway.
Regards
Mike

That also works for me. Being new at this, is there an easy way to apply it to a large spread sheet? I copy, pasted, dragged etc. and it worked but must be an easy way to save and apply to future (larger) sheets.

TIA,

M

Originally Posted by mudraker

For your date problem have a look at,
If that solves the problem it can be built into the macro

That worked fine, Thanks.

The macro leaves "quotes" around each entry. Is it possible to remove them?

Original Table...
-- Table: {1}
{
"music",
"username",
"06/08/2008",
"Created Spread sheet",
},
-- Table: {2}
{
"music",
"username",
"01/29/2007",
"Robert Randolph and the Family Band - Colorblind",
},
-- Table: {3}
{
"music",
"username",
"02/03/2007",
"Cold War Kids - 2007 - Robbers & Cowards",
},

Result after Macro...
"username" "06/08/2008" "Created Spread sheet"
"username" "01/29/2007" "Robert Randolph and the Family Band - Colorblind"
"username" "02/03/2007" "Cold War Kids - 2007 - Robbers & Cowards"

Thanks again,

M