Imagine a dataset representing questions answered by various respondents in a survey. The first column has the Respondent’s Name and thereafter there is one column each for a question posed in the survey. The data extracted from the system suffers from the following fallacies:
1. There are blank rows; and
2. Multiple questions answered by one respondent appear in multiple lines rather than in one line.
One may want to delete the blank rows and consolidate the dataset to show only one row per respondent.
Here’s a snapshot of the source data and expected result
You may refer to my solution in this workbook.
Here’s a short video of my solution
Consolidate multiple rows of data and remove blank rows
{ 3 Comments }