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 Range marked as DATA 1 to be converted to the Range marke as DATA 2.
need the above Range converted to this Range below:
any and all the help is extremely appreciated 🙂
8 Replies
- 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.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.
- Hi Sergei, this would be awesome!! How do I go about doing it? Any suggestions / directions would be great, and I can further research it on different videos please.
Delete all blank rows. Delete all total rows. Delete all duplicate header rows.
You can build a pivot table from what is left.
- Detlef_Lewin
Thank you, Detlef. Much appreciated. Any suggestions on how to put the right values in the pivot table to get the desired result?
