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:


[TABLE="width: 500"]
<tbody>[TR]
[TD]Pop[/TD]
[TD]Task[/TD]
[TD]Shift[/TD]
[TD]Break[/TD]
[TD]Lunch[/TD]
[TD]Break[/TD]
[TD]8/5/19[/TD]
[TD]8/6/19[/TD]
[TD]8/7/19[/TD]
[TD]8/8/19[/TD]
[TD]8/9/19[/TD]
[/TR]
[TR]
[TD]Adults[/TD]
[TD]Walk In[/TD]
[TD]8-4:30[/TD]
[TD][/TD]
[TD]12-12:30[/TD]
[TD][/TD]
[TD]Filsan[/TD]
[TD]Ann[/TD]
[TD]Mihiret[/TD]
[TD]Basma[/TD]
[TD]Gary[/TD]
[/TR]
[TR]
[TD]ADS[/TD]
[TD]Phones[/TD]
[TD]8-4:30[/TD]
[TD][/TD]
[TD]12-12:30[/TD]
[TD][/TD]
[TD]Mai[/TD]
[TD]RaeAnn[/TD]
[TD]Diana[/TD]
[TD]Rebecca[/TD]
[TD]Scott[/TD]
[/TR]
</tbody>[/TABLE]

---

54 Rows later:


[TABLE="width: 500"]
<tbody>[TR]
[TD]Pop[/TD]
[TD]Task[/TD]
[TD]Shift[/TD]
[TD]Break[/TD]
[TD]Lunch[/TD]
[TD]Break[/TD]
[TD]8/5/19[/TD]
[TD]8/6/19[/TD]
[TD]8/7/19[/TD]
[TD]8/8/19[/TD]
[TD]8/9/19[/TD]
[/TR]
[TR]
[TD]Adults[/TD]
[TD]Walk In[/TD]
[TD]8-4:30[/TD]
[TD][/TD]
[TD]12-12:30[/TD]
[TD][/TD]
[TD]Joan[/TD]
[TD]Melinda[/TD]
[TD]Rachel[/TD]
[TD]Naima[/TD]
[TD]Roberta[/TD]
[/TR]
[TR]
[TD]ADS[/TD]
[TD]Phones[/TD]
[TD]8-4:30[/TD]
[TD][/TD]
[TD]12-12:30[/TD]
[TD][/TD]
[TD]Cynthia[/TD]
[TD]Samira[/TD]
[TD]Jason[/TD]
[TD]Rhonda[/TD]
[TD]Ann[/TD]
[/TR]
</tbody>[/TABLE]

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