Quality Alert

Please upload a file (or files) that demonstrate the actual structure (or lack thereof) of the data. Without that, it's difficult to help.

Here you go. 

Thanks for the file. But now please explain what you want to do with it/them.

Say, you have 10 of these sheets what data would have to be extracted to your dashboard?

Rows 4 and 5 (shift, author, date, location, equipment, kanban, and part number) and rows 22 through 24 which are merged and use a dropdown menu to select the non-conformance.

Thank you very much for your help!

Any suggestionss?

I didn't notice your post number 6 until now.

Sorry for being ignorant, but I don't know what you mean. what would you want to extract and how should the end result look like?

I want to use power query to make this attachment.....

Look like this attachment. I have hundreds of them to pull. I am concerned about the "SPLIT" field because it is merged cells.

Come on dude. You ain't even trying on this one. Send an administrator.

I'm afraid PQ can't create a schedule like you attached to post nr 9. It's a formatted report with boarders, colors, a picture, checkboxes, data validation etc. PQ loads data back to Excel in a tabular format, which would then be the basis for further analysis.

You could use PQ to pick-up all the data from separate files (like the example.xlsx) and create one large table. Then I would consider to use Mail Merge in Word to create the forms you need. Just an idea.

And as a general note on merged cells. These do more harm then good and should be avoided as much as possible.

PS: Please don't call me 'dude'!!

Hello,

I assume you want something like the attached file. It's just a quick fix solution that might work with your real data.

In this example I saved your 58314-0A020-split-07-11-24.xlsx three times as 1.xlsx, 2.xlsx and 3.xlsx to C:Temp1 folder. Did some minor changes in 2 and 3 files just to have some differences.

As always, it is better to adjust so that the reported data is entered in a correct format than to try to correct it later on.

Any way, I hope this gives some help on your way forward.

Br,
Anders

Makes sense Anders! I totally misread the OP's intentions. Tack så mycket!!

Anders,

Thank you very much! Your example shows exactly what I want to do. I need to query hundreds of these Quality Alerts. I did more research and learned a bit about removing merged cells when transforming as I was worried about the merged cells in rows 22-24. For this Quality Alert, it resulted in both the shift and the unmerged "SPLIT" cell being in the same column.

Best regards,

Bradley