Notifications
Clear all
Power Query
6
Posts
2
Users
0
Reactions
60
Views
Topic starter
In the attached file -
I get the left source table
And should display the data as in the right table
How can this be done? With Query?
Posted : 13/12/2019 6:59 am
Hi Lea,
Yes, see example attached.
Mynda
Posted : 13/12/2019 7:22 pm
Topic starter
Thank you!
Amazing how much time can be saved with QUERY !!
I just wanted to understand,
What is the purpose of adding the INDEX column - if you later deleted it?
Posted : 14/12/2019 12:21 am
Try deleting it and you will see 😉
Without it you cannot pivot because there would be no 'value' data to Pivot.
Posted : 14/12/2019 7:52 am
Topic starter
אני מצרף אליך את הקובץ עם
הבעיה בגיליון בעיות - הפקודה Pivot Column
הפיכת הטבלה אך הפיכת קו הנתונים לקו כותרת, מדוע זה ??
Posted : 17/12/2019 3:51 am
Hi Lea,
Can you please translate to English as Google translate isn't making sense.
Mynda
Posted : 17/12/2019 7:04 am
