Seperate COL into individual ROWS retaining other COL data the same

[troy001100]

Hi All

I am wanting to seek assistance in with the attached link: https://ibb.co/z5GwQRn

In Table 1 I have COL D which has multiple records separated by a comma
What I want to achieve is what I have displayed in Table 2

So each of the records in COL D will have there own row but still have the same data in col A,B,C & E

Rather than me delimiting COL D and manually update which could be in 100's or 1000's of lines I want a way to VBA it or formula.


Any assistance would be greatly appreciated.

 

[Rick Rothstein]

I think the code I posted in my mini-blog article here might do what you want...

http://www.excelfox.com/forum/showt...into-Separate-Rows-(Keeping-Other-Data-As-Is)

 

[sandy666]

maybe use PowerQuery aka Get&Transform with Split Column - By Delimiter (,) to Rows