Dear all,
I need your help. I have value in Column A, and Column B. In some cells the value in Column B comes with multiple value separated by comma. I need to separate the value in column B and put it in column G. The value should come in Column G in an order like, First Value from column V, second value from Column D, Third Value from E, 4th Value from Column F ( if there is any) and if it is blank, the 5 value should start from Column C second value and it should go on like this. I will appreciate any help . Thanks
I need your help. I have value in Column A, and Column B. In some cells the value in Column B comes with multiple value separated by comma. I need to separate the value in column B and put it in column G. The value should come in Column G in an order like, First Value from column V, second value from Column D, Third Value from E, 4th Value from Column F ( if there is any) and if it is blank, the 5 value should start from Column C second value and it should go on like this. I will appreciate any help . Thanks
Column A | Column B | Column C | Column D | Column E | Column F | Column G | Match Column A and G |
Apple | Apple, Orange, Banana | Apple | Orange | Banana | Apple | ||
Orange | Mango | Mango | Orange | ||||
Banana | Peach | Peach | Banana | ||||
Mango | Avocado | Avocado | Mango | ||||
Peach | Peach | ||||||
Avocado | Avocado |