My original data is like Sheet1 which is not pivot table friendly. Hence i tried to use Query Editor to convert to Pivot table friendly data (sheet2).
However, the Attribute (Column B) become text. And as a result, my pivot table arrangement is not according to date.
Anyone can teach me how to do? And please let me know which part i have done wrong.
Thanks.
Re: Query Editor transforming Cross Tab data but Row header (date) become Text.
in Q-editor use: Using locale
2date.jpg
then use Custom Format for dates on result table (if necessary)
Last edited by sandy666; 06-06-2018 at 05:17 AM. Reason: wrong picture
Do you mean before or after i unpivot the column?
Anyway, where is the Locale? Under which header? I cant seems to find.
open Q-editor
select column with "dates" (dd-mm-yy)
use: using locale and select appropriate zone/country/language
usinglocale.jpg
in this case click ABC (left upper corner of this column)
Last edited by sandy666; 06-06-2018 at 05:36 AM.
Hey, had found the Locale. HOwever, it change the WHOLE column into Date. I onli want the ROw Header. How?
Hi, i realise it change everything to date Except the row header....
WHAT????? row header???
Re: Query Editor transforming Cross Tab data but Row header (date) become Text.
see movie .
If that takes care of your original question, & to say Thanks and for better Motivation, pleaseIf you did it already - ignore it.
- click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then- select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks