excel_learnerz
Board Regular
- Joined
- Dec 12, 2018
- Messages
- 73
Hey guys,
so basically I have a list on the left of companys (company a, company b as example) and list of products for each company (P1, P2, P3) and the revenue
Now I need something like the right hand side where all the products for each company are in a single cell (or even how to have them horizontally and I can concatenate them after) I can use a subtotal on the revenue anyway so I know how to do that bit,
Would anyone know how to get the products horizontally, my list is several thousand lines long,
Thanks in advance,
<colgroup><col><col span="3"><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col></colgroup><tbody>
</tbody><strike></strike>
so basically I have a list on the left of companys (company a, company b as example) and list of products for each company (P1, P2, P3) and the revenue
Now I need something like the right hand side where all the products for each company are in a single cell (or even how to have them horizontally and I can concatenate them after) I can use a subtotal on the revenue anyway so I know how to do that bit,
Would anyone know how to get the products horizontally, my list is several thousand lines long,
Thanks in advance,
Name | Product | Revenue | Name | All products | Total Revenue | |
Company A | P1 | 200 | Company A | P1, P2, P3 | 600 | |
Company A | P2 | 100 | Company B | P1, P2, P3 | 1200 | |
Company A | P3 | 300 | ||||
Company B | P1 | 100 | ||||
Company B | P2 | 800 | ||||
Company B | P3 | 300 |
<colgroup><col><col span="3"><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col></colgroup><tbody>
</tbody>