Forum Discussion
Converting the data from Rows to columns. Or perhaps a Pivot table
I have data in one column, which is repeated in several rows. Those rows have data that I need to restructure in columns. Maybe the sample below makes more sense what I need to do. I need this Ran...
SergeiBaklan
I've tried looking up Power Query. Maybe if you can narrow / pinpoint the direction, I can have a better success. Thank you much in advance.
I've tried looking up Power Query. Maybe if you can narrow / pinpoint the direction, I can have a better success. Thank you much in advance.
If to work with Power Query in any case you need to invest some time and, most probably, money, to become more or less familiar with the tool.
You may start from support pages
About Power Query in Excel - Excel (microsoft.com)
Power Query for Excel Help - Excel (microsoft.com)
which explain basics. Next I'd take some course or go through the book ( like this one https://www.excelguru.ca/blog/2021/08/02/master-your-data-is-now-available/ which recently appeared).
Less systematic approach is to google for concrete questions - lot of resources in the net.