Good afternoon,
I have no clue where to start with this so I am hoping for some advice.
My coworker has a line of data with customer info for a few lines and then purchases at the end. there are 2 types of purchases. This is all on one line. Is there a way to split one line into 2 lines?
for example, it look slike this:
First Name Last Name Address Apples Purchased Oranges Purchased
I want it to look like this:
First Name Last Name Adress Apples Purchased
First Name Last Name Adress Oranges Purchased
Any help would be appreciated, thanks in advanced.
Bookmarks