Hi All,
I need to organize some data coming from a raw spreadsheet into a separated table as displayed below.
<colgroup><col span="2"><col><col span="3"></colgroup><tbody>
</tbody>
RAW DATA: Column A represents countries and column B shows the products sold to each country.
I tried to use VLOOKUP and INDEX/MATCH, but both do not produce the expected results. Also tried using PivotTable, but no satisfactory results as well.
Any assistance is much appreciated.
Cris
I need to organize some data coming from a raw spreadsheet into a separated table as displayed below.
Raw Data | Rearranged Table | ||||
A | B | 1 | 2 | 3 | |
1 | Green | Green | Green | Blue | |
1 | Red | Red | Orange | Green | |
1 | Blue | Blue | Red | Red | |
2 | Green | ||||
2 | Orange | ||||
2 | Red | ||||
3 | Blue | ||||
3 | Green | ||||
3 | Red |
<colgroup><col span="2"><col><col span="3"></colgroup><tbody>
</tbody>
RAW DATA: Column A represents countries and column B shows the products sold to each country.
I tried to use VLOOKUP and INDEX/MATCH, but both do not produce the expected results. Also tried using PivotTable, but no satisfactory results as well.
Any assistance is much appreciated.
Cris