💡𝗧𝗿𝗮𝗻𝘀𝗽𝗼𝘀𝗶𝗻𝗴 𝗗𝗮𝘁𝗮 𝘃𝗶𝗮 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆 💡

Hello and a very good day everyone,

In this post, I shared a 7 #minutes video of transforming data via #PowerQuery.

In this video, I #explained how I used #PowerQuery to transform data. I did via :
1. #Group By (both to count the number of departments and also use All Rows)
2. Use a #function in #PowerQuery called Table.AddIndexColumn to create a sequence for a particular corresponding data.
3. Finally, I perform #pivot column to #transpose the sub-department in respective columns accordingly

Feel free to #view this video.

Should you have any #questions, feel #free to #ask in the #comments section.

Видео 💡𝗧𝗿𝗮𝗻𝘀𝗽𝗼𝘀𝗶𝗻𝗴 𝗗𝗮𝘁𝗮 𝘃𝗶𝗮 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆 💡 канала Learn with Elen 📖📚