Transpose column without using Pivot Table

[slounsbury]

I am trying to create a report that needs to look a certain way that I am having a hard time wrapping my head around how to do. The following tables show the current state of the data and the desired outcome. The date columns are populated with data but will only be used as slicers in the final report. I have tried created a new cacluated table and manually creating each columns but got stuck trying to get the data to populate to the coresponding row.

Current Data State:

Member_Login	Hours_Actual	Type	Date_Start	Date_End	Date_Entered
PersonA	1	Managed Services - Reactive
PersonA	0.5	Managed Services - Proactive
PersonA	4	Internal Paperwork
PersonB	1.3	Internal Managed Services
PersonB	3	Internal Meeting
PersonC	0.25	Managed Services - Proactive
PersonC	6	Managed Services - Reactive
PersonC	2	Internal Technical
PersonC	1	Internal Meeting
PersonD	1	Managed Services - Proactive
PersonD	1	Managed Services - Reactive

Desired Outcome:

Member_Login	Managed Services - Reactive	Managed Services - Proactive	Internal Paperwork	Internal Technical	Internal Meeting	Internal Managed Services	Total
PersonA	1	0.5	4	0	0	0	5.5
PersonB	0	0	0	0	3	1.3	4.3
PersonC	6	0.25	0	2	1	0	9.25
PersonD	1	1	0	0	0	0	2

Any help is appreicated!

[mwegener]

Hi @slounsbury 

so?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[slounsbury]

@mwegener  This is the desired outcome of the look however I should have mentioned that the reason I am not wanting to use a pivot table is so that when the data is exported to a Excel sheet it appears the same. When you export data from a pivot table it just shows the raw data which would be fine if it were in the correct format. 

[mwegener · Accepted solution]

Hi @slounsbury ,

you could pivot your data with Power Query.

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.