Williamsburg
asked on
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.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanx for guiding me,i'll be needing more of your advice
Microsoft Office
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.
80K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
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