Hi Team,
I have an excel file which has the data as shown below. I would like to split the each value into a separate row, Can you please help me?
Domain | Roles |
Finance | Senior Analyst Analyst Lead |
Audit | Manager Senior Analyst Analyst |
Required Output:
Domain | Roles |
Finance | Senior Analyst |
Finance | Analyst |
Finance | Lead |
Audit | Manager |
Audit | Senior Analyst |
Audit | Analyst |
解決済! 解決策の投稿を見る。
Hey @Venamma if you use the Text to Columns tool, in 'Split to Rows' mode, that'll work. You just need to set the delimiter to \n which is the notation for a line break.
This is helpful.
Thank you very much!