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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

maggie - 28 Mar 2008 00:25 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - 28 Mar 2008 03:45 GMT

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.

Signature

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

> Hi,
>
[quoted text clipped - 3 lines]
> person by data in each row, so I don't think that would be a problem. Can
> somebody help? Thanks a lot.

Reply to this Message