Convert a table consisting of columns in sets of 3 into 2 columns assuming that the first column of every set of 3 (field) is duplicated throughout all rows and should be removed. This type of structure is usually returned by facet.pivot responses.
collapse_pivot_names(data)
a data.frame
with every 2 columns
representing a field and value and the final representing
a count
a data.frame