I have two part of data, I want them out put in one sheet.
One part
ffff |
Report Period: Apr 30,2024 |
Currency: CNY |
The other part
B | C | D | E | F | G | H | |
Amount | Over due days | 0 days | 1-30days | 31-60days | 61-90days | 91-120days | >120days |
1000 | 0 | 1000 | |||||
2000 | 10 | 2000 | |||||
3000 | 40 | 3000 | |||||
4000 | 70 | 4000 | |||||
5000 | 100 | 5000 | |||||
6000 | 140 | 6000 |
And between the two part data have one blank row.
To put the data as it looks in an excel, use the reporting tools in Alteryx. Use the Layout tool to create the format and then the Render tool to put into excel.