Split Multiple Lines in a Cell into Separate Cells - Rows or Columns. Text to Columns & Power Query

Download the feature file here: https://www.bluepecantraining.com/exc...

------------------------------------------------------------
Blue Pecan Computer Training Ltd offers on-site or online Excel training for businesses. Training can be delivered at your business premises in the south-east of England or via Teams wherever you are in the world. Visit our training page at https://www.bluepecan.co.uk

In this video I demonstrate how to split multiple lines within a cell in your Excel worksheet into multiple cells. The data can be split into rows or columns. There are two methods for splitting into columns: Text to Columns and Power Query. For splitting into rows you have to use Power Query.

If your version of Excel doesn't come pre-installed with Power Query, you can download it here:https://www.microsoft.com/en-gb/downl...
------------------------