I know this can be done, but just not sure how to do it.
Have an excel sheet with names, address and order info with names appearing as many times as there are orders. Number of orders vary, anywhere from 1-20 or more.
Name1 Order1
Name1 Order2
Name1 Order3
Name2 Order1
Name3 Order1
Name3 Order2
This needs to be sorted and reformated
Name1 Order1 Order2 Order3
Name2 Order1
Name3 Order1 Order2
I tried to push it into Access, but it's the challenge of getting the orders into their own columns. Is there an Access routine for this?
Have an excel sheet with names, address and order info with names appearing as many times as there are orders. Number of orders vary, anywhere from 1-20 or more.
Name1 Order1
Name1 Order2
Name1 Order3
Name2 Order1
Name3 Order1
Name3 Order2
This needs to be sorted and reformated
Name1 Order1 Order2 Order3
Name2 Order1
Name3 Order1 Order2
I tried to push it into Access, but it's the challenge of getting the orders into their own columns. Is there an Access routine for this?