Forum Discussion
Sort Complication
I have an Excel document with an inventory of all my Edison recordings. I sort the file by 'Coupling' but as you can see in the first table when there are multiple records with the same coupling number all the 'L' (Left Side) and all the "R" (Right Side) end up together. What I need is to have the "L" side find its "R" side so they end up like the second table below.
Example: The first 50115-L listed below has its adjoining right side key listed in the 'Joined Record' column - Diamond Disc50115-R2452-A1-46. The matching "R" side would be found by searching the 'This_Records_Join_Field'. I don't know if this is even possible.
| Sorted by Coupling | |||
| Title | Coupling | Joined Record | This_Records_Join_Field |
| Aisha--Indian Intermezzo. | 50115-L | Diamond Disc50115-R2452-A1-46 | Diamond Disc50115-L2468-A1-19 SA |
| Aisha--Indian Intermezzo. | 50115-L | Diamond Disc50115-R2452-A1-19 | Diamond Disc50115-L2468-A1-7 |
| Aisha--Indian Intermezzo. | 50115-L | Diamond Disc50115-R2452-A3-1 | Diamond Disc50115-L2468-A4-1 |
| Aisha--Indian Intermezzo. | 50115-L | Diamond Disc50115-R2452-C2-13 | Diamond Disc50115-L2468-A5-9 |
| Naïla--Intermezzo. | 50115-R | Diamond Disc50115-L2468-A5-9 | Diamond Disc50115-R2452-C2-13 |
| Naïla--Intermezzo. | 50115-R | Diamond Disc50115-L2468-A1-19 SA | Diamond Disc50115-R2452-A1-46 |
| Naïla--Intermezzo. | 50115-R | Diamond Disc50115-L2468-A4-1 | Diamond Disc50115-R2452-A3-1 |
| Naïla--Intermezzo. | 50115-R | Diamond Disc50115-L2468-A1-7 | Diamond Disc50115-R2452-A1-19 |
| Desired Results | |||
| Title | Coupling | Joined Record | This_Records_Join_Field |
| Aisha--Indian Intermezzo. | 50115-L | Diamond Disc50115-R2452-A1-46 | Diamond Disc50115-L2468-A1-19 SA |
| Naïla--Intermezzo. | 50115-R | Diamond Disc50115-L2468-A1-19 SA | Diamond Disc50115-R2452-A1-46 |
| Aisha--Indian Intermezzo. | 50115-L | Diamond Disc50115-R2452-A1-19 | Diamond Disc50115-L2468-A1-7 |
| Naïla--Intermezzo. | 50115-R | Diamond Disc50115-L2468-A1-7 | Diamond Disc50115-R2452-A1-19 |
| Aisha--Indian Intermezzo. | 50115-L | Diamond Disc50115-R2452-A3-1 | Diamond Disc50115-L2468-A4-1 |
| Naïla--Intermezzo. | 50115-R | Diamond Disc50115-L2468-A4-1 | Diamond Disc50115-R2452-A3-1 |
| Aisha--Indian Intermezzo. | 50115-L | Diamond Disc50115-R2452-C2-13 | Diamond Disc50115-L2468-A5-9 |
| Naïla--Intermezzo. | 50115-R | Diamond Disc50115-L2468-A5-9 | Diamond Disc50115-R2452-C2-13 |
