1-Open the workbook you want to adapt
2-Create (if not existing) a fix header
Add lines on the top and copy/paste your header lines
3-Prepare the new query to fit the existing format
Copy-paste the header in a new tab
Display the 'Design Panel' (1)
Open the 'Component' tab (2)
4-Add a new data source
5-Select the new core query
For example BW-DP-Budget Review (Core query)
6-Check/update the selection
7-Insert a Crosstab to see the query result
8-Insert the query in the new tab below the header
9-Adjust the new query to have the same data
10-Delete the cross tab from the old query
For example the cross tab from the Demand Review
