I have a table with a customer and a bunch of line items tied to the customer, and then the next customer and a bunch of line items. Due to the way the information is received there are blank values between customers. I Have
What this is saying is the first three rows are attributed to Customer A and the following three to Customer B
I am trying to get PQ to total the different products and their permutations but I need to assign line items to the customer names.
I am trying to get PQ to check where to put Customer A or B with the following logic:
For each blank cell in the customer column check if there is a value one row above and one column to the right, if those two conditions are met put the value of the row above in the empty cell. So the column immediately below Customer A would see XYZ to the right of it and Customer A above it and populate with Customer A. Then it would continue down each row and perform the same function.
| CUSTOMER | PRODUCT | QTY |
| Customer A | ABC | 20 |
| XYZ | 5 | |
| LMN | 15 | |
| Customer B | ABC | 5 |
| DEF | 50 | |
| GHI | 10 |
What this is saying is the first three rows are attributed to Customer A and the following three to Customer B
I am trying to get PQ to total the different products and their permutations but I need to assign line items to the customer names.
I am trying to get PQ to check where to put Customer A or B with the following logic:
For each blank cell in the customer column check if there is a value one row above and one column to the right, if those two conditions are met put the value of the row above in the empty cell. So the column immediately below Customer A would see XYZ to the right of it and Customer A above it and populate with Customer A. Then it would continue down each row and perform the same function.
