How to combine data from multiple rows when common column headings exist?

I have been searching the forums for a while trying to find my answer but I'm not sure how to word it properly.

I have a fairly large dataset that needs to be exported as CSV. It can not have the same column heading repeated but at this time there are many instances of that happening. I need to consolidate these headings and their respective data into single columns and remove duplicates. I have uploaded an example.

Thanks in advance for your help!

combine_common_columns.xls

try the macro

Thanks for the reply.

I'm not quite sure I understand how to use that macro. I am relatively new to macros, could you explain a quick process for making it work on my data?

The macro will self=adjust to any number of columns and rows of data

the sheets() contains the source and target tab names within the workbook

place a chunk of your data (headings included) in sheet1
clear the contents of the trimmed tab
run the macro

No resulting data in the 'trimmed' sheet after running the macro. Is there a certain version of Excel I need for this to work properly?

Anyone else? I'm trying to run this Macro in Excel 2010 on Windows 7 and I get no result.

OK let's start to audit the process.

1. Does the macro run as posted by me?

2. Once it does, tell me your setuo and I'll make the proper adjustments.

I downloaded your file directly to the machine, opened it in Excel 2010, deleted the contents of "Trimmed", ran the macro.

No resulting data in "Trimmed".

i'll work on it. I tried it and worked the first time..

This version worked!!!

@rcm I didn't get a chance to check your solution.

This worked!
http://stackoverflow.com/questions/1...headings-exist