how to split if the rows with ID
Ex: Consider two columns A & B
A B
1 apple,orange
2 orange,banana
Then how to split the data based on ID. Expected output like below:
A B
1 apple
1 orange
2 orange
2 banana
Asked
Active
Viewed 23 times
1
shrivallabha.redij
- 5,667
- 1
- 11
- 26
Leela Kiran
- 11
- 2
-
consider two columns A & B A B 1 apple,banana 1 orange,fruit It answer should be A B 1 apple 1 orange – Leela Kiran Mar 08 '18 at 12:31
-
This would need vba. Just with excel its not possible – Gowtham Shiva Mar 08 '18 at 12:47
-
1Possible duplicate of [Expand Table with Delimited Column](https://stackoverflow.com/questions/48405462/expand-table-with-delimited-column) – tigeravatar Mar 08 '18 at 14:50