The example I gave shows exactly what I need to do. I have a column of ID numbers with duplicates. I have to make this column hold only unique ID numbers by moving the values to the first row where that ID number appears, with that increasing the number of columns. Hope this makes it a clearer.
RBS -----Original Message----- From: Darren Duncan [mailto:[EMAIL PROTECTED] Sent: 14 December 2006 06:59 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Transpose table Can you please provide a use case for your example, so we know what you're trying to accomplish? That should help us to help you better. -- Darren Duncan At 12:08 AM +0000 12/14/06, RB Smissaert wrote: >I am moving my code away from VBA and transferring it to SQL. >There is one particular routine where I haven't found a good replacement for >and that is to transpose a table from a vertical layout to a horizontal one, <snip> ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
