How do I split data into columns in Google Sheets?

Add two columns.

Note that you'll want to make sure to delete only the single row that contains the values for which you are searching for duplicates.

If your array of values is variable, you may use a helper column to store all values (in the same format as your original data):
After the delete operation completes (you'll know, because the columns you were just working on will disappear), you may copy-paste the helper column as the source data for your second column.

How do you parse JSON into a spreadsheet?

I'm looking for a solution for parsing JSON data in an Excel spreadsheet.

All the examples I can find online have me manually creating a table and adding row data to cells.

What I'd like to see in an Excel spreadsheet is data coming in a table, something like this: Column 1: id1, title1. Column 2: id2, title2. And then being able to use the first column as an index into an array in VBA to pull out the second value of the cell. There are a lot of good questions on SO about how to get data into a spreadsheet, but after poking around I haven't found anything that explains how to parse this sort of data. Use the Range.GetValues method.

Then, loop through the array values, and assign them to variables as needed.