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.
@PhilipMannering has a great solution for your sample data set, but using a RecordID tool to generate the Cross-tab column headers doesn't allow you to have more than 1 WAV # without duplicating the date columns for each wave. The attached WF changes the RecordID to a Multi-row to handle this situation.
Since you also mentioned that you were open to other formatting options, I added a second wf that generates week based column headers.
This has consistent column headers even if the bill date varies between WAV #s as show below