Forum Discussion
Conversion of 'Complex' Google sheet to Excel
Hi There We are currently switching from Gsuite to Microsoft. This involves converting current google sheets to Excel. I have a rather complex sheet with quite a bit of Array functions that ...
Castellum812 Flattening date how you did in the GS file is done with PowerQuery in Excel. I've demonstrated it in the attached file.
Thanks riny,
This is going to be a lot of study.
I'll deep dive tomorrow and see what new question arise 😉
This is going to be a lot of study.
I'll deep dive tomorrow and see what new question arise 😉
Castellum812 This would be a good place to start.
https://exceloffthegrid.com/power-query-introduction/
- Hi Riny,
Only Just started. Sorry for that 😞
I've achieved good progres but bump into some small issues.
After creating a query PQ generates 'Named Ranges' like 'Table1 or Table _1'
If I decide to delete the query, done it a lot during experimenting the 'Named Ranges' do net get deleted.
Under the 'Name Manger' I can change the names for the ranges but I can not delete them.
Is there a way to get rid of these 'Ranges'?