------

%3CLINGO-SUB%20id%3D%22lingo-sub-2221133%22%20slang%3D%22en-US%22%3EREPORT%20MERGING-POWER%20QUERY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2221133%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20have%20been%20struggling%20with%20just%20getting%20data%20out%20from%20multiple%20reports%20to%20one%20end%20report.%20This%20project%20has%20taken%20months%20and%20I'm%20stuck%20and%20very%20desperate.%20The%20data%20is%20pulled%20from%204%20different%20reports%20and%20should%20add%20new%20columns%20based%20on%20new%20information.%20I%20have%20completed%20merges%20but%20results%20in%20too%20many%20rows%20or%20no%20data%20in%20my%20columns%20for%20last%202%20reports.%20Could%20you%20please%20make%20a%20little%20time%20for%20me%20as%20soon%20as%20possible%3F%20I%20will%20be%20filled%20with%20so%20much%20gratitude%20if%20someone%20had%20time%20for%20a%20call.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2221133%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

                   

5 Replies
I don't think phone calls are usually a part of the service here. Is it possible for you to post copies of the spreadsheets you're talking about and what the context is. If the originals contain confidential information, it should be rendered anonymous.

''

By changing names or any other data that could be identifiable. It's hard to know without knowing what the nature of the project is. Could be people's names; could be product IDs; could be dollar amounts. You want the nature of the problem to be discernible but not any truly private, confidential or proprietary data.

Thank you. 

Yes. But all you posted are images. Not much can be done with images. Especially when they're that small (I'm getting old, and working on a desktop)...Is it possible to post here, on the public space, the actual workbook?
I don't use Power Query (it's not available on a Mac); there are others here who do and who could probably help with that. My expertise (if I can presume to use that label) is more in database design and derivation of reports from a well-designed database. My concern with what I've seen is that you have multiple sheets when it might be possible to have just one, made up of a series of separate downloads or reports. But I'm basing that on limited views.

Is the data proprietary? If it is, then I think you'll be better served (unless you can come up with a way to totally disguise it) by finding an Excel consultant in your part of the world...But if you can disguise it, I'm sure that I or somebody else here on this site would be happy to help