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]