Thanks Eric I seem to recall FastXTab from way, way back. I'll take another look at it
Paul Newton -----Original Message----- From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of Eric Selje Sent: 21 May 2019 15:28 To: profoxt...@leafe.com Subject: Re: ? Cross tabulation Sent by an external sender ------------------------------ 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 <paul.new...@pegasus.co.uk> 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: ProFox@leafe.com 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/mn2pr02mb5967649138dfc0cbaf2c5c5aa1...@mn2pr02mb5967.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.