Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Another solution, without the need to rename fields manually. This workflow, though long, finds, formats, and assigns the header row.
I went down a rabbit hole with this one trying to be too clever and then realised there was a much simpler solution...
Probably not the best way to go about it but got the solution!
I feel like my solution is not long, but very cumbersome
not very pretty and I lost some coloumn names in the process, but somehow got there...
Pretty Simple reformatting and configuring
It helped to look at the file in excel first to understand how it was structured....
Could have reduced the tools by having the data 'flags' in the filter itself. Solution attached.