schappelljr
Board Regular
- Joined
- Feb 2, 2009
- Messages
- 55
I am trying to make a list of stores in the order they have been visited. The data has the store name and time of when each transaction has taken place. Sometimes in the same day they will go back to the same store. I want to see what store they have been to and the order they visited in. I tried removing duplicates but it won’t work if they go back in the venue in the same day. I would like to use a pivot table if possible, but any suggestion on how to make this list?
<tbody>
</tbody>
Answer
<tbody>
</tbody>
Store name | time |
Store 1 | 12:00 pm |
Store 1 | 12:30 pm |
Store 1 | 1:00 pm |
Store 2 | 1:39 pm |
Store 2 | 2:00 pm |
Store 1 | 2:30 pm |
Store 3 | 3:30 pm |
Store 3 | 4:00 pm |
<tbody>
</tbody>
Answer
Store 1 |
Store 2 |
Store 1 |
Store 3 |
<tbody>
</tbody>
Last edited: