Hey @bakaidora, I currently have a 'Work in Progress' macro to try and tackle this - restoring original order and names of fields that become affected by Cross-Tab, would you like to try it?
The top (A - After) anchor requires you to plug the data in when the names/orders are messed up. The bottom (B - Before) anchor you just need to plug in at some point beforehand when the field names and order are how you want them:
The underlying workflow here really works on:
1) Transposing your data to get the field names as they are
2) Using a RecordID to make the name of each field 1,2,3 etc so that when they're cross-tabbed, they come out in the correct order
3) Cross-tab your data as you wish - you'll end up with field names such as 1,2,3,4
4) You use a Dynamic Rename tool to look for these names (1,2,3,4....) and replace them with the original headers
I've also attached the demo workflow used in the screenshot above so you can see what's going on.
