I have an xls document in excel 2007. It spans 7 columns. If the value in column a is duplicated in any row I need to merge the rows keeping once instance of the value in column A and adding lines from the duplicate rows within the same row. Basically this is a combine duplicate rows operation but the row should be considered duplicate based on the value in column a only.