Help on formatting - Txt to columns and adding column for each line

[Cesc]

Hi community,

I wanted to ask for help in the following task. I have a list of various thousands menus, which of them have allow lists. I want to separate - text to columns first on the allow lists and then add one line with the menu and its allow list.

Explaining with an example of input and desired output:

Input

Menu	Allow List
SEC1360	Compliance
SEC597	APPaymentsInput,Accountants
SEC6582	APPaymentsInput,AccountReadonly,Accountants
SEC033	APPaymentsInput,CostAccountants,AccountReadonly,Accountants
SEC1360	Compliance
SEC1501	System Setup
SEC1502	SystemAdministration,UserMaintenance,CostAccountants,EngSetup,Accountants

Output

Menu	Allow List
SEC1360	Compliance
SEC597	APPaymentsInput
SEC598	Accountants
SEC6582	APPaymentsInput
SEC6582	AccountReadonly
SEC6582	Accountants
SEC033	APPaymentsInput,
SEC033	CostAccountants,
SEC033	AccountReadonly
SEC033	Accountants
SEC1360	Compliance
SEC1501	System Setup
SEC1502	SystemAdministration
SEC1502	UserMaintenance
SEC1502	CostAccountants
SEC1502	EngSetup
SEC1502	Accountants

[alexnajm · Accepted solution]

Have you tried the Split to Rows option of the Text to Columns tool?

[Cesc]

Thanks Alexnajm, easyone :)