Avatar of vivekrautela

asked on 

How to split the Last column values into multipe rows

Hi All,

I've data that i've to import in CSV format. What i want to do is I want to split the values that are in column N under "Other Permissions" to multiple rows. so the values from Column A to Column M will remain same and the values under column N will come one by one in each row. I've attached the two CSV files for your ref.

Existing Ent Report.csv  --> The original CSV
Required Ent Report.csv --> The required format CSV.

The Data highlighted in yellow will remain same for all rows and the one highlighted in blue will get split up and come as one value for each row.

Please help how i can split the data using the script.

Microsoft ExcelVBA

Avatar of undefined
Last Comment
Martin Liss

8/22/2022 - Mon