Hi All,
I would like to build something like a Auto check Blank in order of a list and then add the values in there, need your assistance
Sample Input Data
Firm | User# | Product | Sales1 | Sales2 | Sales3 | Sales4 | Sales5 | Sales6 | Sales7 | Sales8 |
A | 100000 | Apple | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | Hen |
A | 100000 | Banana | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | Hen |
A | 100000 | Cheery | Amy | Bob | Cindy | Dave | Eason | Frank | ||
A | 100001 | Date | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | |
A | 100001 | Egg | Amy | Bob | Cindy | Dave | Eason | Geo | ||
A | 100001 | Fruit | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | |
A | 100002 | Apple | Amy | Bob | Cindy | Dave | Frank | Geo | ||
A | 100002 | Banana | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | |
A | 100002 | Cheery | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | |
A | 100003 | Apple | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | |
A | 100003 | Banana | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | |
B | 200000 | Apple | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | |
B | 200000 | Banana | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | |
B | 200000 | Cheery | Amy | Bob | Cindy | Dave | ||||
B | 200000 | Date | Amy | Bob | Cindy | |||||
B | 200000 | Egg | Amy | Bob | Dave | |||||
B | 200000 | Fruit | Amy | Cindy | Dave |
Sample Output
Firm | User# | Product | Sales1 | Sales2 | Sales3 | Sales4 | Sales5 | Sales6 | Sales7 | Sales8 |
A | 100000 | Apple | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | Hen |
A | 100000 | Banana | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | Hen |
A | 100000 | Cheery | Amy | Bob | Cindy | Dave | Eason | Frank | X | Z |
A | 100001 | Date | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | X |
A | 100001 | Egg | Amy | Bob | Cindy | Dave | Eason | X | Geo | Z |
A | 100001 | Fruit | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | X |
A | 100002 | Apple | Amy | Bob | Cindy | Dave | X | Frank | Geo | Z |
A | 100002 | Banana | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | X |
A | 100002 | Cheery | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | X |
A | 100003 | Apple | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | X |
A | 100003 | Banana | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | X |
B | 200000 | Apple | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | X |
B | 200000 | Banana | Amy | Bob | Cindy | Dave | Eason | Frank | Geo | X |
B | 200000 | Cheery | Amy | Bob | Cindy | Dave | X | Z | ||
B | 200000 | Date | Amy | Bob | Cindy | X | Z | |||
B | 200000 | Egg | Amy | Bob | X | Dave | Z | |||
B | 200000 | Fruit | Amy | X | Cindy | Dave | Z |
Thank you very much
Solved! Go to Solution.
@k3pineapple here's one way to go about solving your problem. The way I went about it initially is to attach record IDs to each row so I can keep track of the order; using Transpose tool to pivot the table so I have all of the blank cells in a single column; using a Multi-Row Formula tool to specify conditions for populating values in those blank cells.
Hopefully this helped solved your problem!
If so, please mark as solution so others may use it as well!
Thank you very much for the help