Table Visual Grouped Column Headers

[shintamanning]

I have a table visual with 92 columns with 1500 rows.  Each column has it's own column header for example

Customer Name	Customer State	Customer Country	Car Make	Car Model	Car Year Made
Dan	Iowa	USA	Honda	Civic	2018
Matt	Minnesota	USA	Toyota	Camry	1998

I would like the table visual to group the first 3 columns and the last 3 columns with different Group headers without converting it into a matrix/pivot, such that:

        Customer Information          Car Information           

Name	State	Country	Make	Model	Year
Dan	Iowa	USA	Honda	Civic	2018
Matt	Minnesota	USA	Toyota	Camry	1998

I have found solutions for pivot/matrix but not plain ol' Table visual.

Thank you

[shintamanning]

I have tried merge columns but users do not want the column to be merged. They want another heading above the column heading to visually organize the columns below.

[lbendlin]

Again, this is all you.  Create calculated columns or Groups that hold your desired hierarchy levels.

[Anonymous]

Hi @shintamanning ,

You can try merge columns:

The final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PhilipTreacy]

Hi @shintamanning 

Create these new columns in Power Query by concatenating the separate column values then display them in your table.

Phil

[lbendlin]

That's all you - use Power Query for these transforms, or calculated columns.