Hello, I am looking to store orders in excel. What is the best way to store the customer info with multiple line items ordered. I am currently merging the cells so there is 1 row for the name in column A but multiple rows in column G for the different products ordered. This works until we try to alphabetize the data by patient name. Any recommendations?
Solved by O. B. in 15 mins