chrisburns2
New Member
- Joined
- Jun 5, 2015
- Messages
- 1
I have a list of items and their respective PO number and I'm trying to consolidate all items on a PO to one row. So this is what i'm starting with:
PO item
777 beans
777 rice
777 popcorn
33 beans
33 rice
22 popcorn
and this is what i want:
777 beans rice popcorn
33 beans rice
22 rice
POs have varying number of items on them and i want to have it flexible to account for as many as are needed.
Please advise.
Thanks,
Chris
PO item
777 beans
777 rice
777 popcorn
33 beans
33 rice
22 popcorn
and this is what i want:
777 beans rice popcorn
33 beans rice
22 rice
POs have varying number of items on them and i want to have it flexible to account for as many as are needed.
Please advise.
Thanks,
Chris