|List:||General Discussion||« Previous MessageNext Message »|
|From:||Mitchell Maltenfort||Date:||April 12 2010 3:11pm|
|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!
|• reshaping challenge||Mitchell Maltenfort||12 Apr|
|• Re: reshaping challenge||Johan De Meersman||13 Apr|