This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi all, I have a .txt file that I need to transform and I thought the Crosstab tool would do it but I've been having trouble with it.
One record is across multiple rows instead of along one row, separated by null lines. The field names are at the front, then tab and colon :, then the record value.
I've been able to get somewhere by using Crosstab after I add a RecordID and then CEIL the ID divided by the total number of fields, however the result doesn't come out perfectly because the number of field rows is occasionally different across records...
I've added an example to show you guys what I mean exactly, hope that helps? Thanks in advance! 🙂