Hello all, I am new to the forum but have been reading many of your posts. This problem I’m hitting still has me stumped.
On the data document it lists several items for one person. When I bring the data into my report it creates separate rows for each item on my document, the same person is listed multiple times. I know there has be be a way to bring those rows together so I have the person and then in the column for the items it gives me a list. (I’ve tried to merge them and that did not work.) One line should have the person and all their items. Help, how do I do this???
Thank you!