How to transpose table?

[morgancampbell]

My data is as below

	01/10/20	02/10/20	03/10/20
Name1	33	44	34
Name2	3	0	12
Name3	37	28	24

And I want to convert it to the following layout:

Name	Date	Orders Created
Name1	01/10/20	33
Name2	01/10/20	3
Name3	01/10/20	37
Name1	02/10/20	44
Name2	02/10/20	0

How would I go about this?

Thanks,
Morgan

[#2]

@morgancampbell 

Is the number of filled-in date columns fixed? Or does it vary by name?

[#3]

@Hans Vogelaar 

The number of columns are fixed for all names, regardless of data, so some of the cells are 0.

[#4 · Accepted solution]

@morgancampbell 

That's easier with Power Query - query table with data or named range; select column with names; unpivot other columns and do some cosmetic as data types and renaming of columns; land result back.