Excel Power Query Tutorial: How to clean up data which is split into two rows

3,344 views · Published 24 February 2015 · 3:04 · Indexed 4 October 2026

Channel: Efficiency 365 by Dr Nitin · 2015 · Education

Watch on YouTube

This is the worst type of input data to get. Each row has been split into two (or sometimes more) rows. We want those to be combined into a single row.  Find out how in this 3 minute video.  

Read the full blog post here: http://efficiency365.com/2015/10/05/data-split-into-two-rows-cleanup-using-power-query/

Dr. Nitin Paranjape (Office MVP)

More from this channel

• 3:19 Powerpoint Simple to Magical Part 1: Remove background and Animation Demo

  Efficiency 365 by Dr Nitin

  1,216 views · 7 March 2014

• 2:45:46 Office Efficiency Training for Medical Professionals - Session at Nair Hospital Staff Society

  Efficiency 365 by Dr Nitin

  797 views · 5 January 2015

• 4:38 SharePoint Part 3 - Sharing documents securely

  Efficiency 365 by Dr Nitin

  363 views · 5 February 2015

• 5:02 SharePoint Part 9 - Managing Records and Compliance

  Efficiency 365 by Dr Nitin

  342 views · 12 February 2015

• 5:39 SharePoint Part 12 - Branding and Corporate Communication

  Efficiency 365 by Dr Nitin

  268 views · 18 February 2015

• 3:23 SharePoint Part 13 - Field Staff Management

  Efficiency 365 by Dr Nitin

  235 views · 18 February 2015

• 5:23 Excel Error alert: This is the most dangerous mistake you would be making everyday

  Efficiency 365 by Dr Nitin

  1,033 views · 14 May 2015

• 55:13 Dr. Nitin Paranjape's Office Efficiency Webinar (May 2015)

  Efficiency 365 by Dr Nitin

  1,147 views · 30 May 2015