Before discovering this technique, I wasted hours copy/pasting client & competitor ranking data into it’s ‘proper’ place on a spreadsheet. Pivot tables save a LOT of time when working with ranking exports from Linkdex! See how it is done in a few short minutes with this video.
With this pivot table technique:
I left one important step out of the video. The Google pivot table is forcing the data to ‘sum’, so all the keywords with no rank (that show ‘-‘ in the cell) were converted to ‘0’ (zeros).
These zeros need to be replaced with dashes. Be sure to choose ‘Match entire cell contents’ and un-check ‘Search all sheets’