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-bounces@leafe.com On Behalf Of Eric Selje Sent: 21 May 2019 15:28 To: profoxtech@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.Newton@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]