in reply to Transposing rows to columns

... The data I am dealing with is huge
This suggests that a perl-based solution may not work, and a SQL based solution may be more appropriate.

Try some of the ideas proposed in Stackoverflow.

        "You're only given one little spark of madness. You mustn't lose it."         - Robin Williams

Replies are listed 'Best First'.
Re^2: Transposing rows to columns
by simak29 (Novice) on Dec 18, 2014 at 19:57 UTC
    Thank you ..will check that out. I was initially trying it using Pivots on the SQL Server Database, but was getting thrown off at the concatenation. So thought using a data structure might be simpler... No free lunch, right? :)