I have a complex XML schema that contains repeating elements nested inside of other elements. For example, A can repeat. A contains an id and a Name, as well an element B that can repeat. The space between each item of type A will, of course, be X columns long, where X is the total number of rows that all of the B elements take up for that particular A item. At the moment, all of the information contained in A repeats for each of these rows and looks confusing.
My question is: Is there a way to not repeat information, such as Name, but instead have just blank cells?
Visual example:
How it looks now:
A_id Name B_id B_name
1 test1 b1 bone
1 test1 b2 btwo
1 test1 b3 bthree
2 test2 b4 bfour
2 test2 b5 bfive
Much better:
A_id Name B_id B_name
1 test1 b1 bone
b2 btwo
b3 bthree
2 test2 b4 bfour
b5 bfive
Edit: The spacing is messed up, but as you can see the A_id and Name does not repeat for every single row.
Bookmarks