Convert tabular to matrix data layout

preview_player
Показать описание
In this video, I have discussed how to extract "Convert a tabular to a matrix data layout" using Power Query.

Рекомендации по теме
Комментарии
Автор

Exactly what I was looking for! Thank You!

captonsiluvairajan
Автор

Hi Ashish, if let say my data supposed to have 43 columns, but the data i have has only 41 columns, (because column 39 & 40 has no data), how I export in such a way it will show 43 columns with blank values on columns #39 & #40?

And how do I display my column in descending order, from to 43 ... -> to 1?

Thanks in advance!

alana.alexander
Автор

I don't really get the Power Query. A lot easier for me just to use MS Access.

MrMurfle
welcome to shbcf.ru