Scenario: The assembly items and the corresponding Items have been provided as per the following. The component column needs to be changed to the different columns based on assembly items. Follow the below Copy the Assembly Items column to the next column(in between the A and B columns. So now columns A and B contain… Continue reading Text Join Function in Excel