Data merge is strictly a simple tool. It cannot handle variable numbers of fields other than to delete blank lines.
It's great for things like address labels and directories.
do you know if Adobe has a better product for answer my needs
Adobe does not, but there are some commercial catalog plugins for ID that might work.