Hi all, I am having a problem getting a table in a way I want it to look like. For example, my table is the following, ID_number  SUB_number ID1                 SUB1 ID1                 SUB2 ID2                 SUB3 I am wondering if there is a query that can transform my table into the following ID_number     SUB_number       SUB_number2 ID1                   SUB1                    SUB2 ID2                   SUB3 ( SUB1 and SUB2 are associated with the same ID1) Please advise. ... View more