Forum Discussion
Need help with data-formula
I have a table where I have names in the first column, various services offered by them in the next columns, and the accounts served in the next columns:
| Name | Service1 | Service2 | Service3 | Account1 | Account2 | Account3 |
| A | X | we | rd | xx | yy | zz |
| B | Y | rd | X | zd | zf | zg |
| C | Z | Y | X | cd | xx | ht |
| D | we | R | rd | se | sr | st |
| E | X | we | Rd | ht | hy | hu |
I have a list of unique accounts from columns E, F and G above in rows, and Unique services from columns B, C and D above as column titles. Now I want all the names to populate that are at the intersection of the above. Something like table below:
| Accounts | X | Y | Z | R | J | we | rd |
| xx | A, C | C | C | A | A | ||
| ht | C, E | C | C | E | E |
No RepliesBe the first to reply