siddharthnk
New Member
- Joined
- Jun 20, 2013
- Messages
- 48
Hi All,
I have two columns with data. Column A has names of sectors and column B has names of accounts within those sectors. The accounts will be repeated over several rows. What I need is a formula which will stack up the unique accounts per sector in different columns. It would be great if you could help me with a formula which would help me do this.
<TBODY>
</TBODY>
I have two columns with data. Column A has names of sectors and column B has names of accounts within those sectors. The accounts will be repeated over several rows. What I need is a formula which will stack up the unique accounts per sector in different columns. It would be great if you could help me with a formula which would help me do this.
Sector</SPAN> | Accounts</SPAN> |
Consumer Products</SPAN> | Companhia de Bebidas Das Americas</SPAN> |
Automotive</SPAN> | Toyota</SPAN> |
Automotive</SPAN> | Ford</SPAN> |
Consumer Products</SPAN> | Clorox Corporation</SPAN> |
Consumer Products</SPAN> | Companhia de Bebidas Das Americas</SPAN> |
Automotive</SPAN> | Toyota</SPAN> |
Consumer Products</SPAN> | Diageo plc</SPAN> |
Consumer Products</SPAN> | Companhia de Bebidas Das Americas</SPAN> |
Automotive</SPAN> | Ford</SPAN> |
Pharmaceuticals</SPAN> | Cardinal Health</SPAN> |
Consumer Products</SPAN> | Hansen Natural Corporation (HANS)</SPAN> |
Consumer Products</SPAN> | Clorox Corporation</SPAN> |
Consumer Products</SPAN> | Companhia de Bebidas Das Americas</SPAN> |
Automotive</SPAN> | Toyota</SPAN> |
Consumer Products</SPAN> | Kimberly-Clark Corporation</SPAN> |
Consumer Products</SPAN> | Diageo plc</SPAN> |
Electronics</SPAN> | Hewlett-Packard</SPAN> |
Pharmaceuticals</SPAN> | Cardinal Health</SPAN> |
Steel</SPAN> | ArcelorMittal</SPAN> |
Chemicals</SPAN> | Sinochem</SPAN> |
Personal care products</SPAN> | Johnson & Johnson</SPAN> |
<TBODY>
</TBODY>