# Joining Multi Value Cells Not Completing **URL:** \ **Category:** Data cleaning and transformations\ **Created:** [November 6, 2023, 4:22pm UTC](https://forum.openrefine.org/t/joining-multi-value-cells-not-completing/1044 "2023-11-06T16:22:16Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![MRoth](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@MRoth](https://forum.openrefine.org/u/MRoth)\ **Post date:** [November 6, 2023, 4:22pm UTC](https://forum.openrefine.org/t/joining-multi-value-cells-not-completing/1044/1 "2023-11-06T16:22:16Z")
I am attempting to join multi-value cells and the action is not being performed. OpenRefine includes the action in the Undo/Redo panel, but the cells are still separated. I have it set to "Show As: Records." I have tried on both Chrome and Firefox with the same result. I am using Version 3.7.6 with Java. ---
**Author:** ![ostephens](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/ostephens/32/8_2.png) [@ostephens](https://forum.openrefine.org/u/ostephens)\ **Post date:** [November 7, 2023, 2:41pm UTC](https://forum.openrefine.org/t/joining-multi-value-cells-not-completing/1044/2 "2023-11-07T14:41:04Z")
@MRoth are you able to share a screenshot or some example data? My guess is that OpenRefine isn't recognising the rows are part of the same record, but it's hard to know if this is right or why this is happening without an example. ---
**Author:** ![MRoth](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@MRoth](https://forum.openrefine.org/u/MRoth)\ **Post date:** [November 7, 2023, 3:13pm UTC](https://forum.openrefine.org/t/joining-multi-value-cells-not-completing/1044/3 "2023-11-07T15:13:39Z")
![OpenRefine Joining Cells Not Working](https://europe1.discourse-cdn.com/flex017/uploads/openrefine/original/1X/88eb36868ba3c7629f472b7a3cd0a98e20b7cd96.png) One thing I found this morning is that blank rows are disappearing when the column is split. ---
**Author:** ![ostephens](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/ostephens/32/8_2.png) [@ostephens](https://forum.openrefine.org/u/ostephens)\ **Post date:** [November 7, 2023, 3:16pm UTC](https://forum.openrefine.org/t/joining-multi-value-cells-not-completing/1044/4 "2023-11-07T15:16:18Z")
Thanks! I can see that although you are in "records" mode, the rows in the display are all being treated individually - this can be seen because of the alternative shading (white/grey) on each row. If you scroll to the lefthand of the project, what are the values in the first column? This first column will be the one that determines how the rows are grouped together into records - and at the moment it looks like the grouping is one row equals one record, rather than the record grouping together several rows ---
**Author:** ![MRoth](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@MRoth](https://forum.openrefine.org/u/MRoth)\ **Post date:** [November 7, 2023, 3:31pm UTC](https://forum.openrefine.org/t/joining-multi-value-cells-not-completing/1044/5 "2023-11-07T15:31:03Z")
Right now the first column is empty. My department is waiting for files to upload into a repository to get a URL for it. ![OpenRefine Joining Cells Not Working - First Column](https://europe1.discourse-cdn.com/flex017/uploads/openrefine/original/1X/334f7f1dd493307ac399f4f9a09e8799bb60d5f0.png) ---
**Author:** ![ostephens](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/ostephens/32/8_2.png) [@ostephens](https://forum.openrefine.org/u/ostephens)\ **Post date:** [November 7, 2023, 3:40pm UTC](https://forum.openrefine.org/t/joining-multi-value-cells-not-completing/1044/6 "2023-11-07T15:40:57Z")
The way that Records are calculated in OpenRefine is by looking for values in the first column. So with a blank first column OpenRefine isn't going to recognise the rows as part of a single record. So in this case it looks like you could achieve this by: 1. Move the `ES..Title` column to the left so it is first in the project 2. Switch to "Rows" display mode 3. Use the `Edit cells -> Blank down` option in the `ES..Title` column 4. Switch to "Records" display mode You should then find that OpenRefine correctly groups together the rows into records - you are looking for display like: ![Screenshot 2023-11-07 at 15.39.03](https://europe1.discourse-cdn.com/flex017/uploads/openrefine/original/1X/b7479e0dcd443d3ceb24ffa7040ec446d044e66f.png) You can see that although there are 3 rows, only the first one is numbered in the `All` column indicating that (in this example) all three rows belong to a single record. Hopefully at this point your 'join multi-valued cells' operation on your other column should work as expected ---
**Author:** ![MRoth](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@MRoth](https://forum.openrefine.org/u/MRoth)\ **Post date:** [November 7, 2023, 4:05pm UTC](https://forum.openrefine.org/t/joining-multi-value-cells-not-completing/1044/7 "2023-11-07T16:05:40Z")
Great! It works like a charm. I also tried with moving the column only (not blanking down) and it also worked. Thank you so much for your help!