List:General Discussion« Previous MessageNext Message »
From:Mitchell Maltenfort Date:April 12 2010 3:11pm
Subject:reshaping challenge
View as plain text  
I have a table with two columns, ID and order.  Each ID can be
repeated up to 16 timers.

I need to reshape it so that I have one row per ID, and columns
order1, order 2,...order 16, and one number that lists how many orders
there actually were.

No this is not a homework assignment.  I'm trying to make sense out of
a legacy project.

Can someone help me out?

Thanks!
Thread
reshaping challengeMitchell Maltenfort12 Apr
  • Re: reshaping challengeJohan De Meersman13 Apr