I have a spreadsheet exported from MYOB ...
The format makes it useless for my purposes without a lot of manual deleting and copy/paste, so I'm trying to clean it up automatically.
4 Columns:
<tbody>
</tbody>
Above is a simplified version of what I have.
What I'd like to do is combine the good info on one row (preferably in 3 cells)
Prod-1-Code Prod-1-Name 2 (total quantity)
The problem is that each Product has a different number of rows of "Useless Info"
So what I'm trying to do is say:
If the text in columns B and C matches
THEN
get A, B and D and put it somewhere.
I've tried a few ways and failed and I've not had much luck Googling as it's a bit difficult to describe what I want to do.
I really hope this makes sense to someone
Thanks in advance
webecho
The format makes it useless for my purposes without a lot of manual deleting and copy/paste, so I'm trying to clean it up automatically.
4 Columns:
| A | B | C | D | Row Number | |
| Product ID | Product Name | Date | Quantity | 1 | |
| Prod-1-Code | Prod-1-Name | 2 | |||
| Useless Info | Useless Info | Useless Info | 1 | 3 | |
| Useless Info | Useless Info | Useless Info | 1 | 4 | |
| Prod-1-Name | 2 | 5 |
<tbody>
</tbody>
Above is a simplified version of what I have.
What I'd like to do is combine the good info on one row (preferably in 3 cells)
Prod-1-Code Prod-1-Name 2 (total quantity)
The problem is that each Product has a different number of rows of "Useless Info"
So what I'm trying to do is say:
If the text in columns B and C matches
THEN
get A, B and D and put it somewhere.
I've tried a few ways and failed and I've not had much luck Googling as it's a bit difficult to describe what I want to do.
I really hope this makes sense to someone
Thanks in advance
webecho
