Convert Data in Columns to data in rows - Transcribe doesn't do what I need

[ga1205]

Hello,

I have a workbook with data formatted as follows:

	A	B	C	D	E... BZ
1	Location	Item	DType	Week1	Week2...
2	100	ABC	qty	3	5
3	100	ABC	rev	30	50
4	100	DEF	qty	0	3
5	100	DEF	rev	0	90
6	101	ABC	qty	-1	5
7...1MM+	101	ABC	rev	-8.5	42.5

<tbody>
</tbody>

Where the weekly quantity and revenue numbers are in rows and the weeks are in columns. I find this format difficult to work with and would prefer it to be set up as:

	A	B	C	D	E
1	Location	Item	Week	Qty	Rev

<tbody>
</tbody>

Is there an easy way to make this work? I've got a few tabs with ~1 million rows in each.

Thanks for your hlep!

 

[sheetspread]

The reverse pivot table does this:

https://www.youtube.com/watch?v=xmqTN0X-AgY

 

[ga1205]

The reverse pivot table does this:

https://www.youtube.com/watch?v=xmqTN0X-AgY

Thanks. Looks interesting... not sure it will solve my problem though. A bigger issue is I don't seem to have the Pivot Table Wizard on my version (15.27) of Excel for Mac. Any other way to go about doing this?

Thanks for the help.

 

[sheetspread]

Oh I think it's gone in 2016, let me think of something else

 

[sheetspread]

Do you have Power BI (probably not)?
I don't know how VBA code written in windows would transfer to mac
If you have MS Query in Excel that could be your best option.
Or MS Access or SQL Server