Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011
    Posts
    1

    Unanswered: Converting Rows to Columns

    Here is the data I'm working with:


    Field1 - Field 2 - Field 3 - Field 4
    Order# - Trans# - Empl. - Type
    Item - 100.00 - 50.00 - 50.00


    I need to somehow have this data displayed as follows:


    Field1 - Field2 - Field3 - Field4 - Field5 - Field6 - Field7 - Field8
    Order# - Trans# - Empl. - Type - Item - 100.00 - 50.00 - 50.00


    Any help with be very appreciated.

    Thanks!
    - Matt

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    I guess that there are more than 2 rows in the table. How would the system know that the rows:
    Order# - Trans# - Empl. - Type
    and
    Item - 100.00 - 50.00 - 50.00
    pertains to the same subset and must be concatenated together?
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •