column data to headers

[Mina2021]

Hi,

I have date set and is there any way to make Column- channel's data as header. Is there any option to do it on interface?

Something look like  below-

Date	Code	Learning	RTC	Delima	RemoteRTC
12/7/2011	1100091	0	1	1	0

If anyone could help me would be helpful. 

[messi007]

@Mina2021,

Not sure I get what you need:

Based on this input:

Could you please tell what you expect to have?

It will help us to give you the expected output.

Regards

[Mina2021]

Hi messi007,

Need to convert the above table into below format  

and the Action column's values are given based on the diff channels.

[messi007]

@Mina2021,

The Excel file you attached is different of what you're showing.

Could you please share the data of the last screen shot.

Best Regards

[Mina2021]

Apologies.

Here you go.

[Luke_C]

@Mina2021 

It sounds like you just need a crosstab tool. This will let you choose the column that the headers should be sourced from, and which column the data under each header should come from. 

[messi007]

@Mina2021,

Here you go

Regards,