21 May
2019
21 May
'19
1:43 p.m.
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