Make a tall table wide

  • How do you take a 'tall' table and make it wide? What I am trying to do is make a table that is like

    Job, seq #, Value

    look more like

    job, seq 1 Value, seq 2 Val, seq 5 Value, seq 137 Value ...

    My current attempts make a table somewhat like this, but I end up with a ton of rows, each with just one of the values in it, the rest are nulls.

  • PIVOT can solve your problem.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply