This is regarding SharePoint 2007, I have 3 list in a site called "A", "B", "C".
I have combined this 3 lists in one and created a new list called "D" using SharePoint Designer 2007.
Now showed the List "D" fields or data on webpart in designer but it's not coming up as I expected.
I'm giving here as an example of 3 list.
After joining this 3 lists using JoinView in Designer, result showing up as given below.
And I need to show these 3 list fields or data as given below.
Can you please help?