I am trying to make a powershell script that splits the values in the second row of an excel sheet by commas and writes it back into the same sheet
Example there is 2 columns Header and Header2
Under Header is a,b,c and under Header2 is d,e.
I want it to split into under Header1 is a b c in separate cells and under Header2 is d and e in separate cells
New contributor
Keith Mok is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.