Look Who it Was Random video

Excel - Sort Excel Data Where Each Record Occupies Three Rows - Episode 1176

349 views · Published 2 February 2010 · 2:13 · Indexed 6 October 2026

Channel: MrExcel.com · 2010 · Education

Watch on YouTube

Microsoft Excel Tutorial: Sort data where each record occupies three rows.

Welcome to the MrExcel podcast. In this episode, we'll be discussing a common issue faced by many Excel users - dealing with data that is spread out over multiple rows. This can be a frustrating problem, but fear not, as we have a solution for you.
The question for today's episode comes from Eric, who has a spreadsheet where each record takes up three rows. This means that there is data in the grey section, followed by numbers in the yellow section, and then more numbers in the white section. To make matters worse, there are also two headings at the top of the spreadsheet. So, how do we deal with this? 
To solve this problem, we will be using a function called "sequence". First, we will insert a couple of columns and then use the sequence function to create a series of numbers. Next, we will use the "SortKey" function to sort the data based on the numbers we just created. This will bring all the data for each record together, making it easier to work with. We can then delete the extra rows and columns, leaving us with a clean and organized spreadsheet. 
There are also other ways to solve this issue, such as converting the data to values and then using the sort function. Whichever method you choose, the key is to have a systematic approach to organizing the data. Thank you, Eric, for sending in your question and thank you to all our viewers for tuning in. We hope this episode has been helpful and we'll see you next time for another netcast from MrExcel!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Introduction and Sponsorship
(00:10) Question from Eric about dealing with data in multiple rows
(00:20) Inserting a row and using sequence to organize data
(00:41) Using SortKey to sort data by name and values
(01:42) Deleting extra rows and columns
(01:56) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Copying and pasting values in Excel
Deleting extra rows and columns in Excel
Excel data manipulation
Excel data organization techniques
Excel tips and tricks
Inserting rows and columns in Excel
Sorting data in Excel
Spreadsheet data organization
Using the sequence function in Excel


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152786/



Erik asks how do deal with data where each record takes up three rows. Episode #1176 shows you how.

More from this channel