Forum Discussion
Transposing Muti-Data Sets to Single Program
Hello, Looking for some help with this. I am aware of transposing the data, but not sure how to pull the program name down for every date value in the array. Looking for either the manual manipu...
Hi Anonymous ,
According to your description, here is my solution.
Click "transform data" to enter Power Query Editor.
Use Power Query to unpivot the other column. Please select the first column, right click it and then click "unpivot other columns".
Final output:
Best Regards,
Community Support Team _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much for your help and support! This is exactly what I needed!