Translating a horizontal data set to a pivot table friendly vertical format

[TaxSloth]

So I'm working with a horizontal table that tracks a count of calls per week per employee, currently formatted as

Name	1/3-1/7	1/10-1/14	1/17-1/21	1/24-1/28	1/31-2/4	2/7-2/11
EMPLOYEE A	249​	292​	107​	212​	226​	218​
EMPLOYEE B	425​	447​	214​	203​	419​	352​
EMPLOYEE C	429​	459​	397​	382​	362​	372​
EMPLOYEE D	106​	103​	68​	80​	79​	97​

And I'm attempting to shift the format to this -

EMPLOYEE NAME	WEEK	CALLS MADE
EMPLOYEE A	1/3-1/7	249​
EMPLOYEE B	1/3-1/7	425​
EMPLOYEE C	1/3-1/7	429​
EMPLOYEE D	1/3-1/7	106​
EMPLOYEE A	1/10-1/14	292​
EMPLOYEE B	1/10-1/14	447​
EMPLOYEE C	1/10-1/14	459​
EMPLOYEE D	1/10-1/14	103​

The problem I keep running into is current excel can't seem to learn that pattern, so autofill won't work. I've got a functional offset function for translating the Week over using Offset, but I can't figure out how to fill in the call data since it needs to shift rows and columns. I also want this vertical variant table to update with the new data input into the original horizontal version, which is limiting me to using cell references instead of just direct pasting the numbers one set at a time.

So I'm looking for one of two solutions, ideally -

1. An easier way to shift the original horizontal table into a pivot table friendly vertical table than what I'm currently doing

or

2. A formula that will refer to a different sheet, fill in X amount of rows in column Y, then shift to column Y+1 and post X amount of rows again. I need the pattern to repeat 52 times since this is a yearly report by work week and I'm working with a set of 9 employees.

 

[Automatrix]

Power Query: Select all the date columns --> unPivot Columns.

Book1
	A	B	C	D	E	F	G
1	Name	1/3-1/7	1/10-1/14	1/17-1/21	1/24-1/28	1/31-2/4	2/7-2/11
2	EMPLOYEE A	249	292	107	212	226	218
3	EMPLOYEE B	425	447	214	203	419	352
4	EMPLOYEE C	429	459	397	382	362	372
5	EMPLOYEE D	106	103	68	80	79	97
6
7	Name	Attribute	Value
8	EMPLOYEE A	1/3-1/7	249
9	EMPLOYEE A	1/10-1/14	292
10	EMPLOYEE A	1/17-1/21	107
11	EMPLOYEE A	1/24-1/28	212
12	EMPLOYEE A	1/31-2/4	226
13	EMPLOYEE A	2/7-2/11	218
14	EMPLOYEE B	1/3-1/7	425
15	EMPLOYEE B	1/10-1/14	447
16	EMPLOYEE B	1/17-1/21	214
17	EMPLOYEE B	1/24-1/28	203
18	EMPLOYEE B	1/31-2/4	419
19	EMPLOYEE B	2/7-2/11	352
20	EMPLOYEE C	1/3-1/7	429
21	EMPLOYEE C	1/10-1/14	459
22	EMPLOYEE C	1/17-1/21	397
23	EMPLOYEE C	1/24-1/28	382
24	EMPLOYEE C	1/31-2/4	362
25	EMPLOYEE C	2/7-2/11	372
26	EMPLOYEE D	1/3-1/7	106
27	EMPLOYEE D	1/10-1/14	103
28	EMPLOYEE D	1/17-1/21	68
29	EMPLOYEE D	1/24-1/28	80
30	EMPLOYEE D	1/31-2/4	79
31	EMPLOYEE D	2/7-2/11	97
Sheet8

 

[TaxSloth]

Power Query: Select all the date columns --> unPivot Columns.

Book1
	A	B	C	D	E	F	G
1	Name	1/3-1/7	1/10-1/14	1/17-1/21	1/24-1/28	1/31-2/4	2/7-2/11
2	EMPLOYEE A	249	292	107	212	226	218
3	EMPLOYEE B	425	447	214	203	419	352
4	EMPLOYEE C	429	459	397	382	362	372
5	EMPLOYEE D	106	103	68	80	79	97
6
7	Name	Attribute	Value
8	EMPLOYEE A	1/3-1/7	249
9	EMPLOYEE A	1/10-1/14	292
10	EMPLOYEE A	1/17-1/21	107
11	EMPLOYEE A	1/24-1/28	212
12	EMPLOYEE A	1/31-2/4	226
13	EMPLOYEE A	2/7-2/11	218
14	EMPLOYEE B	1/3-1/7	425
15	EMPLOYEE B	1/10-1/14	447
16	EMPLOYEE B	1/17-1/21	214
17	EMPLOYEE B	1/24-1/28	203
18	EMPLOYEE B	1/31-2/4	419
19	EMPLOYEE B	2/7-2/11	352
20	EMPLOYEE C	1/3-1/7	429
21	EMPLOYEE C	1/10-1/14	459
22	EMPLOYEE C	1/17-1/21	397
23	EMPLOYEE C	1/24-1/28	382
24	EMPLOYEE C	1/31-2/4	362
25	EMPLOYEE C	2/7-2/11	372
26	EMPLOYEE D	1/3-1/7	106
27	EMPLOYEE D	1/10-1/14	103
28	EMPLOYEE D	1/17-1/21	68
29	EMPLOYEE D	1/24-1/28	80
30	EMPLOYEE D	1/31-2/4	79
31	EMPLOYEE D	2/7-2/11	97
Sheet8

I'm operating on a Mac, and as I understand it I currently lack access to the majority of PowerQuery features. If this is one of the functions I have access to, I do not know where to find it.

 

[Automatrix]

I'm afraid you are right. Do you have access to office.com or Teams?

 

[TaxSloth]

Yes, I can sign into office.com.

 

[Automatrix]

You may be able to use some Power Query functionalities there, but I'm not sure (and unable to test it at the moment).

 

[TaxSloth]

You may be able to use some Power Query functionalities there, but I'm not sure (and unable to test it at the moment).

It does not appear that I can, unfortunately. So I'll likely need an alternate suggestion for shifting the caller data.