Transpose Data

[Ykankam]

How do I transpose data in the excel sheet (on the left) to look like the output on the right?

I want to transpose or pivot in such a way data I see the short description and see it's corresponding monthly FTE.

I don't want user and short description repeating.

[andhiii079845]

Copying layout from SSRS und Excel is not to goal of Power BI 😉

[Ykankam]

How specifically do I do this?

[andhiii079845]

1:1 is not possible in my opinion. But can you please upload some sample data. I can try it but I wil not copy it from a screenshot.

[Ykankam]

Month starts on

End Date

Group

User

Hours

FTE

Person Days

Category

Parent category

Number

Short description

Quarter

Remarks

1/1/2023

1/31/2023

OpsIT - Biologics Region

Francis, Maria

44.00

0.25

5.50

Project Allocated

Allocated

T1PRJ0299366

Biologics: FMC - Discoverant Maintenance and Expansion

Q1

OPS IT CC

2/1/2023

2/28/2023

OpsIT - Biologics Region

Francis, Maria

40.00

0.25

5.00

Project Allocated

Allocated

T1PRJ0299366

Biologics: FMC - Discoverant Maintenance and Expansion

Q1

OPS IT CC

3/1/2023

3/31/2023

OpsIT - Biologics Region

Francis, Maria

46.00

0.25

5.75

Project Allocated

Allocated

T1PRJ0299366

Biologics: FMC - Discoverant Maintenance and Expansion

Q1

OPS IT CC

4/1/2023

4/30/2023

OpsIT - Biologics Region

Francis, Maria

40.00

0.25

5.00

Project Allocated

Allocated

T1PRJ0299366

Biologics: FMC - Discoverant Maintenance and Expansion

Q2

OPS IT CC

5/1/2023

5/31/2023

OpsIT - Biologics Region

Francis, Maria

46.00

0.25

5.75

Project Allocated

Allocated

T1PRJ0299366

Biologics: FMC - Discoverant Maintenance and Expansion

Q2

OPS IT CC

[andhiii079845]

You want to show this matrix on the right side on Power BI?!

[Ykankam]

Yes, that is how I want it