| 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 challenge | Mitchell Maltenfort | 12 Apr |
| • Re: reshaping challenge | Johan De Meersman | 13 Apr |
