How do I combine columns that are in different rows into one?

M

maggie

Hi,

I have an Excel document that contains at least two records, for an
individual. In my Word document, I would like to combine the Excel field,
Salary, from both rows for an person. How do I do that? I can identify a
person by data in each row, so I don't think that would be a problem. Can
somebody help? Thanks a lot.
 
D

Doug Robbins - Word MVP

You should do the manipulation in Excel - possibly using a third sheet that
contains only one row for each person and which then uses a SumIf() function
to combine the information relating to each person. Then use that sheet as
the data source.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining three files when middle file has sections with endnotes 2
Format column widths from one table to a separate table on same page 1
Merging from an Excel file with graphics 1
VBA word change keys 0
How to center adjust text above and image in a two column document. 1
Adding a big matrix in Word 2013 5
Combining comments using different versions of Word 0
How do I combine records from different sources 0

Top