Summarise and cross tab - Single Line Output

Question

Hi Community - In the sample excel, I have a few lines of the same invoice. I want to summarise it together into a single line with the Tax Rate as SGST and CGST coming under two columns. I tried using summarise and cross tab, but it is coming into two lines instead of one. Can someone please help?

Chess Corp.xlsx

Qiu · Answer

@Akshay_Dakalia 
I feel it might be something like this, but can not be sure.
Hope you check this one and fine it useful.

0316-Akshay_Dakalia.yxzp

Akshay_Dakalia · Answer

Thanks for checking this for me.

Please find enclosed the snips as requested. Please let me know if you need anything else.

Alteryx Desired Output.png

Alteryx Output.png

OTrieger · Answer

@Akshay_Dakalia 
Please share a print screen on how the data is looking in Alteryx the 2 lines that you are referring to, and a print screen on how you would like to have the data.