We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
I don't understand why the posted solution bothers to split with that filter; just adding new sequence numbers and cross-tabbing back does the job.
I tossed out the HTML bit and added 100 records in a text box just for demo/test purposes.
Solution posted below.
I confess I'm confused by all the transposing and crosstabbing in the proposed provided solution. All it seems to do is leave all the fields enormous. A simple Dynamic Rename (for the column headers) and Auto Field (to adjust the field sizes, and in particular the boolean types) seems to do the trick one the file is parsed. Am I missing something?