Hello All,
I receive an Excel file weekly where the table is already in pivoted format with the below-mentioned headers.
Please advise what do I need to do as a power query step to select the column headers marked in green because the columns with date header is subject to change where past month columns will be retained and new months getting added.
I receive an Excel file weekly where the table is already in pivoted format with the below-mentioned headers.
Please advise what do I need to do as a power query step to select the column headers marked in green because the columns with date header is subject to change where past month columns will be retained and new months getting added.
Adoption Manager or CSM |
Opportunity Owner (Sales) |
Opportunity ID |
Opportunity Name |
Customer Name |
Mfg Part/SKU # |
Option Code |
Item Description |
11/1/2023 |
12/1/2023 |
1/1/2024 |
2/1/2024 |
3/1/2024 |
4/1/2024 |
5/1/2024 |
6/1/2024 |
7/1/2024 |
8/1/2024 |
9/1/2024 |
10/1/2024 |
11/1/2024 |
12/1/2024 |
1/1/2025 |
2/1/2025 |
3/1/2025 |
4/1/2025 |
File Name |
Product Type |
Sales Stage |
PL |
NPI EOL Notes |
SKU Status |
Row Validation |
Flexworker SKU |
Sales Territory ID |
Platform ID |
Distributor |
Country |
Billing Type |
SKU + Option Code |