Excel output with merged column heading

[ramesh_neel]

Hi Guys,

I have data in the below format 

Product	Order Date	Ship Date
P1	01-Jan-20	04-Jan-20
P2	02-Jan-20	05-Jan-20
P3	06-Jan-20	06-Jan-20

and want to produce an excel output shown as below, 

	Ordered	Shipped
Product	01-Jan-20	02-Jan-20	06-Jan-20	04-Jan-20	05-Jan-20	06-Jan-20
P1	1			1
P2		1			1
P3			1			1

This looks simple, but I am not sure how to create the top sub header (ordered and shipped). Any help would be appreciated!

[DavidP]

Would this work?

[ramesh_neel · Accepted solution]

@DavidP  - Not really 😞 but thanks for your efforts , I managed to fix it myself using a report text and summarize tool! (Attached the workflow)

[DavidP]

@ramesh_neel, every day is a school day! I wouldn't have thought of using the summarize tool to combine reporting objects.

I'm definitely banking that idea!

[ramesh_neel]

@DavidP  - Me neither! I think that feature is a life saver!