troubleshooting Question

How to split the Last column values into multipe rows

Avatar of vivekrautela
vivekrautela asked on
Microsoft ExcelVBA
9 Comments2 Solutions97 ViewsLast Modified:
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.

Join our community to see this answer!
Unlock 2 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros