Transfer Multiple Data From Multiple Rows to one Column (Transpose form)

[gary2014]

I have attached two files:

1. Case count and Daily time (File with Data)
2. New Consolidated Sheet (Destination file where, I would like to see the data in transpose form).

Please help

[Paul_Hossler]

What have you tried so far?

[p45cal]

Power Query solution in the attached. Currently filtered for only Shane and David for comparison with your results.