I get an excel report every day with open invoice numbers in a column, (other columns include $$, date, Quanity, etc) so as you read across the row it has all the information you need about the invoice. I would like to pull the column of invoice numbers out of each file and have the first date of invoices in column A the next days Invoices in Column B and so on. Each File name is the date of the report so I would like the file Name as the header of each column. Is this possible...
The final report would have all of the file names in row 1 and the list of invoice numbers below each file name. Thanks...
(I'm looking to be able to put the report in a folder every day and just rerun the query and I have the next days list of invoices in the next column)
I can pull all of the invoices ## but I just get one big column from all of the files... How do I get it into columns by file name.
Hi Paul,
Yes, I think so (caveat is because I haven't seen a sample file). You can Pivot the data in Power Query. You'll probably need to add an Index column otherwise the pivot will return errors. When you Pivot make sure you choose 'Don't Aggregate' for the Invoice numbers.
You'll end up with the invoice numbers stepped down the rows in line with the Index numbers. See example attached.
Mynda
