If the leftmost table was loaded into powerquery (data … from table range, [x] column headers) add column … custom column … with formula = {[Start Serial] … [End Serial]} then use arrows atop the column to expand into rows. File close and load 1 solved How to obtain the consecutive numbers between two numbers … Read more
Final try on this one Use Home…advanced editor… and paste this function into PowerQuery. Name it: fnReadFile (zFile)=> let Source = Csv.Document(File.Contents(zFile),[Delimiter=”#(tab)”, Columns=1, Encoding=1252, QuoteStyle=QuoteStyle.None]), #”Added Index” = Table.AddIndexColumn(Source, “Index”, 0, 1), // Date row includes text “Date: ” DateFind = Text.Replace(Table.FindText(#”Added Index” , “Date”){0}[Column1],”Date: “,””), // Row preceeding data includes text “>>>” CaratFind = … Read more
Sorry for the length of this response, but there are a lot of steps involved and I included quite a bit of screen clips as well. I believe this solution does what you are looking for. I start with files in a folder: Feb-19.xlsx contains two tabs: Jan-19.xlsx contains three tabs: I open a new … Read more
Import the data1, first transpose the table, then promote the headers Import data2 with promoting the headers Append data1 and data2 as new Appending Result 4 solved Power Query Two Excel Files with No Header Row in Each Files [closed]
I was able to solve it by using the Workbook.Query object. here is my solution. Public Sub FunctionToTest_ForStackOverflow() ‘ Doug.Long Dim wb As Workbook ‘ create empty workbook Set NewBook = Workbooks.Add Set wb = NewBook ‘ copy queries CopyPowerQueries ThisWorkbook, wb, True End Sub Public Sub CopyPowerQueries(wb1 As Workbook, wb2 As Workbook, Optional ByVal … Read more