Hi,
I have been charged with converting forms sent in to us in Excel into a new layout that we are implementing. I've been running into a bit of trouble with doing this on a mass scale.

The original format is 2 columns, the first holds the 7 field headers, and the second holds the data.

VMV_CODE xxxx
VARIABLE_CODE xxxx
VARIABLE_GROUP Test
VARIABLE_NAME Test
UNIT_CODE MG/L
METHOD_CODE xxxx
DETECTION LIMIT xxxx
E_DESCRIPTION Test

Many groups of these fields are sent in at a time, and the groups are seperated by an empty row.

The new layout is the same, but transposed horizontally to rows.

How can I automate this to be able to select/copy many of these groups of data at a time and paste them into the new layout, making sure the field names aren't copied over more than once? I don't believe the empty cells would be a problem since they'd be pasted at the end of the rows of data anyway.

The only different in the new layout is that the "Detection_Limit" and "Unit_Code" fields need to be concatenated together.

Thanks for any advice you can give me.