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, like this example:
ID Value ------------- 1 A 1 B 1 A 3 G 3 D 5 A This should become: ID Value1 Value2 Value3 ------------------------------------ 1 A B A 3 G D 5 A I can't see any way to do this fast and my VB method running on arrays was very fast. Does anybody have any suggestions how to handle this? Thanks for any advice. RBS ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
