I get unique records from a data base that instead of giving me vertical information on the same record I get 3. How can I create a query that will take the 3 records and make them one. Example pasted below. One Doc # and 3 columns. I would like to move up the Obligation and Expenses to one row with the Commit
Doc Commit Obligation Expense 10WRMPP12 4689736 10WRMPP12 897459 10WRMPP12 54271 Any help is appreciated
Thank you
Gene