Can I unpivot multiple non-contiguous rows to columns?

[Mark_E]

I am trying to import six regional schedules, each with a separate sheet for each week of the month.
When I pull all of the sheets in through power query the dates are scattered on various rows throughout the aggregated editor view.

Is it possible to unpivot all of the rows with dates to columns? I can only get the initial week to do so, and would prefer not to have to do a separate query to each sheet for each region if possible.

The Date is structured like:

---

74 Rows later:

Pop	Task	Shift	Break	Lunch	Break	8/5/19	8/6/19	8/7/19	8/8/19	8/9/19
Adults	Walk In	8-4:30		12-12:30		Filsan	Ann	Mihiret	Basma	Gary
ADS	Phones	8-4:30		12-12:30		Mai	RaeAnn	Diana	Rebecca	Scott

<tbody>
</tbody>

---

54 Rows later:

Pop	Task	Shift	Break	Lunch	Break	8/5/19	8/6/19	8/7/19	8/8/19	8/9/19
Adults	Walk In	8-4:30		12-12:30		Joan	Melinda	Rachel	Naima	Roberta
ADS	Phones	8-4:30		12-12:30		Cynthia	Samira	Jason	Rhonda	Ann

<tbody>
</tbody>

I want to end with a list of for example, all Adults Walk-Ins grouped by date, but I am not sure of it is possible with the mess I have.

Thanks,
Mark

 

[Mark_E]

That works great, thanks.

 

[sandy666]

You are welcome