Hi! Can anyone help me please? I have data where the last 3 Columns have multiple data in each cell using Alt+Enter. I need to split the multiple data into one row for each data and for each row the first column is copied. Please see below:
I have used the Code submitted by Apo here in this thread and it works great for the Column "Types" but I need to perform it in two other columns.
I have thousands of records and any help will be appreciated.
Thanks
I have used the Code submitted by Apo here in this thread and it works great for the Column "Types" but I need to perform it in two other columns.
I have thousands of records and any help will be appreciated.
Thanks