I’m having some issue to split the column from 1 to 2 as the column is under all WrapText, is anyone can help me on this? I have attached the Excel file as below.
Sheet 1 is the original data I have
Sheet 2 is the result I need.
Appreciate your help on this issue. Thanks.
Data.xlsx (11.4 KB)