In a spreadsheet I have two lists (key-value pairs basically) that look like this:
[A] [B] [D] [E] a 23 b hello b 42 d world c 11 f good f 17 g bye h 88
And I would like to get something that looks like this:
a 23 - b 42 hello c 11 - d - world f 17 good g - bye h 88 -
Is there a way to achieve this inside Google Sheets? I could download the csv file and write a program for it, but looking around on this site it seems that Google Sheets is powerful and a lot of these things can be done without leaving it.