Data formatting

Question

Hi, the image from Alteryx needs to be converted into the format that is presented in the below screenshot from excel. I wont need the formatting in black but I would like to have the data being split for the purpose of preparing charts from the data. Please suggest the approach in this regard.

Christina_H · Answer

Something like this (figures are made up)

You technically don't need the layout tool, you can attach the header directly to the table, but that leaves an empty row between table and header.

Tables.yxmd

satya04 · Answer

Can you please elaborate? And all the metrics need to be on the same sheet.

Christina_H · Answer

I think the simplest approach would be to create tables in Alteryx and lay them out vertically before rendering into Excel.  That could also include the black headers.