Area Codes
In the sheet1 i have
Australia - Adelaide 61-88x 0.0102
Australia - Melbourne 61-38,39 0.0102
Country - Area, Country Code, Rate
In the Sheet2 I have
Australia - Adelaide 61-88x 61882,61883,61884,61881
Australia - Melbourne 61-38,39 6138,6139
I need all the codes in one tab to each row Please let me know if anyone
have solution for this in Excel. It should look Like below.
Australia - Adelaide 61882 0.0102
Australia - Adelaide 61883 0.0102
Australia - Adelaide 61884 0.0102
Australia - Adelaide 61881 0.0102
Australia - Melbourne 6138 0.0102
Australia - Melbourne 6139 0.0102
Please help me if any one have solution
|