Hi Folks.
I am combining a lot of excel tables using powerquery. All the tables that were combined originally had names with dates. Ie 10.1.21, 10.7.21, etc. When I made my query it gives them these names. How do I get it to display the proper date for the names?
Row Labels
Query1!ExternalData_1
Table_query
Table_query__1
Table_query__10
Table_query__11
Table_query__12
Table_query__13
Table_query__137
Table_query__2
Table_query__227
Table_query__238
Table_query__3
Table_query__30
Hello ExcelSam7 and Welcome to Excel Forum.
We might have a better understanding of the issue if we could see a sample file with a few Excel tables and the manually produced example of the output showing what you would like to get from Power Query.
Instructions for attaching a file are given in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks