Forum Discussion
Nextif Function and Mail Merge
Hi Fabio,
Not sure if {NEXTIF} field helps for the grouping, but that's more question to Word people. From poor Excel point of view you may transform your source table and make grouping here, for example with Power Query
Simple sample file is attached
- The bottom example from the screenshot is EXACTLY what I need to help with an email mail merge from Word. We have presenters that have multiple sessions. We are trying to send only 1 email per presenter. After following your suggestion, I have been able to to get Power Query to bring all the sessions into 1 cell, but am not sure how to make each show on its own line within the same cell. Can you share that, please?
Sorry, not sure I understood. Perhaps you may provide small sample file with manually added desired result.
SergeiBaklan Yes, in the examples you provided to the question. You shared the idea for using Power Query in Excel instead of NextIF in Word. The first image shows multiple rows for each person in the Name column with different information for Date and Amount. In the 2nd image shown after applying Power Query to the sheet, it shows 1 row per Name with multiple lines within each row for Date and Amount.
I found several great videos on merging and grouping data to the same row when they had a common name/data to group them by, but they all just extended into one long line. Your example does not appear to use text wrap to fix this as there seems to be plenty of space in the Date column to have the 2nd date in the same line as the 1st date. What did you do to get the 2nd line within the row?
Thanks for replying back so quickly. I appreciate your help.
