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.
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
Hi messi007,
Need to convert the above table into below format
and the Action column's values are given based on the diff channels.
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
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.