@rizkaamelia_rct , you may need to check your CSV file to ensure it is in the correct format. If it is not formatted properly, it may not work as expected.
@Victorpaisano25 , you should be able to achieve the desired format by following the instructions as outlined in the steps shared below:
Step 1:
Open the CSV file. You should see your CSV file in the following structure:
[Image 1]
Step 2:
Select the column that contains the data.
[Image 2]
Step 3:
Select Text to Columns data tool from the Data Tab.
[Image 3]
Step 4:
By default, you will see Delimited being selected. Now press Next.
[Image 4]
Step 5:
Select Semicolon and press Nex…