consolidate record