ExcelBanter - Combining Two Files

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Combining Two Files (https://www.excelbanter.com/excel-worksheet-functions/126700-combining-two-files.html)

PaulL

Combining Two Files

I have two worksheets stemming from an origional set of data. Both share one
common column of "case numbers" but the other data in each is distinct. Is
there a way to merge the two worksheets together so that all data for each
case number is appended or merged into a single row?

Dave F

Combining Two Files

Doesn't copy & paste do that?
--
Brevity is the soul of wit.

"PaulL" wrote:

I have two worksheets stemming from an origional set of data. Both share one
common column of "case numbers" but the other data in each is distinct. Is
there a way to merge the two worksheets together so that all data for each
case number is appended or merged into a single row?

All times are GMT +1. The time now is 02:48 AM.