Hi,
I have two SharePoint 2013 list- Master and Child from designed by InfoPath 2013. The users enter data from the master list to the child list and see all rows from the child list on the master list through a secondary data connection. The first two columns are always duplicate as follows-
Row1: A1 - B1 - C1 - D1;
Row2: A1 - B1 - C2 - D2;
Row3: A1 - B1 - C3 - D3;
Row4: A1 - B2 - C1 - D1;
Row5: A1 - B2 - C2 - D2;
Now, I want only one A1, one B1 and B2 to be displayed like a group - as follows-
Row1: A1 - B1 - C1 - D1;
Row2: C2 - D2;
Row3: C3 - D3;
Row4: B2 - C1 - D1;
Row5: C2 - D2;
And, same for A2 filed. Could anybody guide me how to do this?
Thanks in Advance.