Jump to content

Use first row of certain data cells when next row is empty


Recommended Posts

I would like a rule that repeats the first row of data of all columns in an Excel file except for one column called "name" which will have multiple rows of data.



Basically, the agenda items, times and dates are repeated for each person's name.



Please see Windows FusionPro Version 10.1.11 Template attached and excel file




I would appreciate any help.

Welcome__Itinerary_Brochure_v2_bleeds (002) - TESTING 1.zip

Link to comment
Share on other sites

I'm assuming you want an entirely separate output record (i.e. different pages) for each person.


So, do you want the exact same agenda for each person? If Yes, then I would put the agenda and the name list in different data files, and use the name list file as the main input data file for job, and read the agenda as an external data file.


If you want each person to have their own agenda, I would do something similar to my solution here:


Link to comment
Share on other sites

  • 3 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...