Hi Friends
Can we extract table names from a sheet. I have more than 150 tables in a sheet. Is it possible to get a list of table names in some cells like a list?
Thanks for your feed back
Regards
Hi Friends
Can we extract table names from a sheet. I have more than 150 tables in a sheet. Is it possible to get a list of table names in some cells like a list?
Thanks for your feed back
Regards
Appreciate clicking the * Add Reputation button on your left side, if you want say thanks to me
Try:
This will give you a list in the debug window. Easy enough to change this to write the list to another worksheet.Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks