Forum Discussion
Combining Excel Tables
Hi Anonymous ,
Perhaps you can do this by doing the following：
1. After connecting to the spreadsheet, right-click the file name and select Transform Data (don't select each individual sheet):
2.Modify the M code by changing the second argument to "true" (prevents repetition of column headers)
3.In the Data column, click the Expand icon (double arrow) & Uncheck "Use original column name as prefix".
Here's a similar case and a detailed explanation of how to do it.Combining Data From Multiple Worksheets Into one table
Hope it helps,
Community Support Team _ Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Perhaps you can do this by doing the following：
1. After connecting to the spreadsheet, right-click the file name and select Transform Data (don't select each individual sheet):
2.Modify the M code by changing the second argument to "true" (prevents repetition of column headers)
3.In the Data column, click the Expand icon (double arrow) & Uncheck "Use original column name as prefix".
Here's a similar case and a detailed explanation of how to do it.Combining Data From Multiple Worksheets Into one table
Hope it helps,
Community Support Team _ Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.