Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I combine columns that are in different rows into one?
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I combine columns that are in different rows into one?
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 "maggie" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data in columns i.o. rows | Mailmerge | |||
Combine columns fr: Excel - Link to labels in Word | Mailmerge | |||
Hiding Rows and Columns | Tables | |||
'Tables'- 2 columns,4 rows. Can you merge one column into 3 rows? | Tables | |||
Combine text with footnotes above columns section on same page | Microsoft Word Help |