Forum Discussion
Re-Using Combine and Transform Data query
Yes, though it's tricky to explain!
The helper queries are only so much "help" to you here, so you need to undo a bit of what Power Query did automatically.
So find "Transform Sample File" you have to delete the last few steps so that all you have left there is "Source".Now you should see a table where the first column ("Name") is the name of each sheet and the second column "Data" has an icon in the title bar on the right with two arrows pointing in opposite directions. Click on that, and then on "OK".
Now when you go back to your main query (perhaps called "Query1") it should all be sorted. Or you may have to delete the "Changed Type" column at the end. The sheet names are still in that first column.
Hope that helps, let me know if not.
Matt
============
If I helped please mark as solved and click on the thumbs up as this helps others as well as me!
Resolver IIYes, though it's tricky to explain!
The helper queries are only so much "help" to you here, so you need to undo a bit of what Power Query did automatically.
So find "Transform Sample File" you have to delete the last few steps so that all you have left there is "Source".
Now you should see a table where the first column ("Name") is the name of each sheet and the second column "Data" has an icon in the title bar on the right with two arrows pointing in opposite directions. Click on that, and then on "OK".
Now when you go back to your main query (perhaps called "Query1") it should all be sorted. Or you may have to delete the "Changed Type" column at the end. The sheet names are still in that first column.
Hope that helps, let me know if not.
Matt
============
If I helped please mark as solved and click on the thumbs up as this helps others as well as me!
Hi Coriel-11 ,
Apologies for the delay in responding. Your idea was great and has solved my problem. Thank you so much for your help
Kind regards,
Paul