![]() We want to sort first by Make and then by Model as the screen shot above shows. All the vehicles of the same make need to be next to each other for this technique to work.įirst, we select all the cells, and choose Sort from the Data menu tab. To combine the rows for each make of vehicle, we are going to build a few columns that help us stitch together the multiple rows, but first we need to make sure the list is sorted. 5Download the Combine Multiple Rows Example File. ![]() 4Cleaning Up the Helper Columns and Finalizing the List.2Building the Concatenation Helper Column.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |