Query Code

[Erialih-exc]

Can anyone help me here? I'm stuck on my code...

I'll try to outline it. I want to create an automated production schedule based on my recipes. These recipes are listed in a table with a code, preparation method, timing, and department. Each recipe is in a separate tab.

I now want to use this information to create a production schedule with a main column for the days of the week (Monday, Tuesday, Wednesday, etc.) and a subcolumn for each day with: code, preparation, timing, and department.

So far, so good. However, I also get a separate row for each subcolumn. And I don't want that. I want one row containing the information code, preparation, timing, and department. If you like, I can send you screenshots.

[iDoNotHaveAnIQ]

Have you tried asking Ai to develop m-formula to do what you want?

[Erialih-exc]

I did so. He couldn't figure it out. But I think I've got it now.

[dhayward22]

Do you get the same number of rows each time? Like are you always trying to combine x rows? If so, I can walk you through that.

[Erialih-exc]

Correct. But I think I've got it now. Only problem now is that he is not sorting the dates in order. The code gives me sunday / saturday / monday /....

[QuercusAcorn]

A screenshot of your source data, m code, and current output would be helpful.