HI Team,
Hoping you can help me.
I have an excel which has two Columns;
ID : Column A
Account Code : Column B
| ID | Account Code |
| 2533642 | |
| | |
| 1529358 | 341060 |
| 9380529 | 264672, 264690 |
| | 340230 |
| 570804 | 340290 |
What i would like to achieve is, for a given account Code (Column 
where the ID (Column A) is populated then provide me a unique row for every combination
NB: There can be multiple account codes associated to an Id, and these are separated out via a comma
Expected Result #
| ID | Account Code |
| 1529358 | 341060 |
| 9380529 | 264672 |
| 9380529 | 264690 |
| 570804 | 340290 |
Looking forward to your help
