•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power Query-source file adds a new column weekly. How to remove old columns
I am using Power Query to combine multiple files. However, one of the source files gets a new column every week. Basically the new column is current status column and the other columns turn into a timestamp of what the status was in the previous weeks.
I only really care about the most recently added column+the static columns (e.g. from below I would only need the transaction + 2/20 update columns). Is there a way to automate this within Power Query or would the best option be to remove the extra, older columns manually whenever I get an updated file (others use the older columns so I can't request the columns be removed from the source file)?
Source file example format:
| Transaction | 1/23 update | 1/30 update | 2/6 update | 2/13 update | 2/20 update |
|---|---|---|---|---|---|
| 1 | ETA 3/30 | ETA 3/30 | ETA 3/30 | ETA 2/23 | ETA 3/6 |
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Power Query
#source file
#new column
#old columns
#combine multiple files
#current status column
#timestamp
#automate
#remove columns
#manual removal
#static columns
#transaction
#update columns
#ETA
#source file example
#file update
#data processing