Many thanks Ted for those very helpful pointers. In fact I went with FastXTab and had the result I wanted in just a few minutes.
Paul Newton -----Original Message----- From: ProfoxTech <[email protected]> On Behalf Of Ted Roche Sent: 21 May 2019 18:45 To: [email protected] Cc: [email protected] Subject: Re: ? Cross tabulation Sent by an external sender ------------------------------ (Replying to Eric because I never see Paul's original posts) July 2006 Advisor Answers: http://www.tomorrowssolutionsllc.com/Articles/Create%20Cross-tabs.PDF and the FoxWiki Tamar references: http://fox.wikis.com/wc.dll?Wiki~CrossTab~VB http://fox.wikis.com/wc.dll?Wiki~MatXTab (with download link) On Tue, May 21, 2019 at 10:28 AM Eric Selje <[email protected]> wrote: > There's a cross-tab wizard that comes with VFP, but I'd look at this > VFPX > project: https://github.com/VFPX/FastXTab > > Eric > > > On Tue, May 21, 2019 at 8:43 AM Paul Newton > <[email protected]> > wrote: > > > Hi all > > > > I have data like this: > > Tablename Auditdate Auditsize > > CTRAN 01/01/2019 25 > > PTRAN 01/01/2019 30 > > STRAN 01/01/2019 35 > > CTRAN 01/02/2019 30 > > PTRAN 01/02/2019 35 > > STRAN 01/02/2019 40 > > CTRAN 01/03/2019 35 > > PTRAN 01/03/2019 40 > > STRAN 01/03/2019 45 > > > > And I want to process it in such a way that it ends up like this > > > > TableName 01/01/2019 01/02/2019 01/03/2019 > > CTRAN 25 30 35 > > PTRAN 30 35 40 > > STRAN 35 40 45 > > > > I realise that the dates would have be converted to valid field names. > > Anybody have ideas/suggestions? Does anybody know of a tool that > > would achieve this? > > > > Many thanks > > > > Paul Newton > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/bn8pr02mb5954b47238396bea7797ae60a1...@bn8pr02mb5954.namprd02.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
