Create refreshable Power Query from two spreadsheets
UpworkUSNot specifiedintermediateScore: 47
Microsoft ExcelPower QueryScripts & UtilitiesData EntryData AnalyticsData AnalysisData ExtractionData VisualizationData CleaningData MiningData InterpretationVisual Basic for ApplicationsAnalytics DashboardExcel MacrosSpreadsheet Macros
Hello!
I have a need for a refreshable power query. I have one spreadsheet with a tab called MASTERDATA with several columns of data. Two specific columns are: InvoiceID and Inv Date. (Dates are pre=populated through 2024. Dates from 2024 to today have the InvoiceID, but no date. I have a second spreadsheet that contains the InvoiceID and InvoiceDate. (This needs pre-work to clean it up, as the data is in two column data blocks that repeat after each InvoiceID. ) I need to join the two, and match the InvoiceID, then fill in the missing dates into the MASTERDATA. This process needs to be refreshable, as new rows and new data blocks will be added monthly.
Unlock AI Intelligence, score breakdowns, and real-time alerts
Upgrade to Pro — $29.99/mo