in reply to Invert CSV

Not a Perl answer, but since MS Office 2007 and OpenOffice 3, this is no longer an issue. Also, inverting = select the rows and columns you want to switch, cut, paste special, transpose

Replies are listed 'Best First'.
Re^2: Invert CSV
by JavaFan (Canon) on May 30, 2011 at 20:28 UTC
    Also, inverting = select the rows and columns you want to switch, cut, paste special, transpose
    Of course, if your tools cannot deal with that many columns, you won't even get to the stage where you can select...
Re^2: Invert CSV
by Gulliver (Monk) on May 31, 2011 at 14:07 UTC

    Thanks for posting that. I didn't realize that 2007 and OpenOffice could now handle that many columns. I just tried it with 10,000 columns.

Re^2: Invert CSV
by roadtest (Sexton) on May 31, 2011 at 16:30 UTC
    Thanks for your information. Microsoft is doing right thing this time:-)