Forum Discussion
Consolidating and manipulating data from different workbooks into one workbook
I have to say, not that it's immediately helpful to you, that it's not even clear why you've converted the originals to Excel. The only apparent "value" that Excel might offer is in its ability to array things in cells that happen to be neatly organized in rows and columns. Beyond that, however, none of this seems to actually USE Excel for calculating, summarizing, cross-tabulating--the things at which Excel excels.
And (although I could be wrong about this) I can't imagine Power Query being helpful either, for the simple reason that the data aren't arrayed as tables.
So where I'm going with all that is to ask you some questions:
- WHAT is the nature of the original reports?
- From what system(s) do they come? In what kind of form(s)?
- Might it be possible to take them and convert them to tabular data (single records on a single row) SO THAT Power Query could work on them?
Original report generated from internal system in PDF. Can only convert to Word, Excel, or Word pad. Limited to generic reports and cannot customize. Need to consolidate test results from the top report in the image into the control status report. Cumbersome process. Excel was the better option.
Thank you for your assistance. I appreciate your level of effort. Take care.
