Forum Discussion
How do I make text to columns automated?
Hi there - I will be doing some reporting and have one column with some data separated by commas, I need to separate the data into columns and then make that rule apply to any further data I add to t...
Hi
You might consider using Power Query. It's one single step for splitting at a Delimiter and send the data back to Excel . Sample attached.
Steps:
- Convert your list into a Table (CTRL + T)
- Click on the Data Tab and Select : "From Table" >> The Query Editor Opens
- On the Home Tab Click on "Split Columns" >> Select By Delimiter ", " and each occurrence
- On the Home Tab >> Close and Load
When source data Changes, just hit Refresh.
Hope That Helps
Nabil Mourad