Multiple fields in a matrix header

[kc08h]

Hi,

I'm looking to "stack" data fields into the header. Any ideas how to make this happen? Thank you!

This is how it looks:

Staff Member	Requisition	Role Title	Company	Offer Letter Sent	Orientation	Forms Signed	Badge Issued	Start Date
John Doe	XYZ12345	Power BI Specialist	Google	1/1/2023	1/15/2023	1/15/2023	1/17/2023	1/25/2023
Jane Does	XYZ12346	Power BI Specialist	Google	1/1/2023	1/15/2023	1/15/2023	1/17/2023	1/25/2023
John Smith	XYY12439	Developer	Google	1/1/2023	1/15/2023	1/15/2023		1/25/2023
Jack Smith	LKS92839	Developer	Amazon	1/1/2023	1/15/2023	1/15/2023	1/17/2023	1/25/2023
Jane Smith	KJSAJ929	Consultant	Amazon	1/1/2023	1/15/2023	1/15/2023	1/17/2023	1/25/2023

This is how I would like it to look:

	John Doe	Jane Does	John Smith	Jack Smith	Jane Smith
	XYZ12345	XYZ12346	XYY12439	LKS92839	KJSAJ929
	Power BI Specialist	Power BI Specialist	Developer	Developer	Consultant
	Google	Google	Google	Amazon	Amazon
Offer Letter Sent	1/1/2023	1/1/2023	1/1/2023	1/1/2023	1/1/2023
Orientation	1/15/2023	1/15/2023	1/15/2023	1/15/2023	1/15/2023
Forms Signed	1/15/2023	1/15/2023	1/15/2023	1/15/2023	1/15/2023
Badge Issued	1/17/2023	1/17/2023		1/17/2023	1/17/2023
Start Date	1/25/2023	1/25/2023	1/25/2023	1/25/2023	1/25/2023

[pmreis]

Hi @kc08h 

• 
  You can make the transformation needed in the following order:
  
  Unpivot other columns except first 4 columns
  Merge first 4 columns
  Pivot Value and don't aggregate
  
  

let
    Source = Data,
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(Source, {"Staff Member", "Requisition", "Role Title", "Company"}, "Attribute", "Value"),
    #"Merged Columns" = Table.CombineColumns(#"Unpivoted Columns",{"Staff Member", "Requisition", "Role Title", "Company"},Combiner.CombineTextByDelimiter(",", QuoteStyle.None),"Merged"),
    #"Pivoted Column" = Table.Pivot(#"Merged Columns", List.Distinct(#"Merged Columns"[Merged]), "Merged", "Value")
in
    #"Pivoted Column"

PFA a file with a solution in a PBIX HERE.

Please consider marking it as solved for other users to find it.