Microsoft Office
--
Questions
--
Followers
Top Experts
cross Tab querry inExcel 2007
hi,
how does the corss tab querry in Excel works, mine works but does not display the values,instead it displays the sum,min,max stuff like that.
how does the corss tab querry in Excel works, mine works but does not display the values,instead it displays the sum,min,max stuff like that.
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
so what should be used , its like i ave to normailized data.
the data is like:
sourceID NeighbourID
4133 12324
4133 45465
4133 45460
2345 45567
2345 48796
1234 35456
it shoulde be like:
SourceIID NeighbourID1 neighbourID2 Neighbourid3
4133 1234 45465 45460
2345 45567 48796
1234 35456
thanx,
i'll be waiting for your reply
the data is like:
sourceID NeighbourID
4133 12324
4133 45465
4133 45460
2345 45567
2345 48796
1234 35456
it shoulde be like:
SourceIID NeighbourID1 neighbourID2 Neighbourid3
4133 1234 45465 45460
2345 45567 48796
1234 35456
thanx,
i'll be waiting for your reply
thanx for guiding me,i'll be needing more of your advice
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Microsoft Office
--
Questions
--
Followers
Top Experts
Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.