Hi! Here's my problem. Basically, I need the data that is on the table on the left to look the one on the right.
Order IDs listed on B, the item/s ordered on C, and the status is on D. I need the pending orders listed on the table on the right so that:
a) Only the pending orders are shown
b) IDs are listed but not repeated, as on column F.
c) items are listed as well but this time, they are quantified, instead of showing them in several rows as on the table on the left. eg. Order 633745 with 3 avocados
Sorry, English is not my native language. I tried to explain it the best I could. I hope someone can help me. I need to make this work through formulas and not thru VB. But if there is no other way, then VB would be fine.
Thanks in advance!
Order IDs listed on B, the item/s ordered on C, and the status is on D. I need the pending orders listed on the table on the right so that:
a) Only the pending orders are shown
b) IDs are listed but not repeated, as on column F.
c) items are listed as well but this time, they are quantified, instead of showing them in several rows as on the table on the left. eg. Order 633745 with 3 avocados
Sorry, English is not my native language. I tried to explain it the best I could. I hope someone can help me. I need to make this work through formulas and not thru VB. But if there is no other way, then VB would be fine.
Thanks in advance!
Last edited by a moderator:
