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.

Turn this…

linkdex export

Into this…

ranking comparison using pivot table

With this pivot table technique:

Please note:

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’

replace zeros with dashes