Forum Discussion
Re-ordering spreadsheet
Hi, I'm new to the forum and hope this question makes sense. I have a spreadsheet with financial information that I use to prepare my tax return. The rows are different securities. The columns are di...
Hi guywe
according to your description, this sounds like a perfect task for Power Query. You would need to load your table into Power Query and there is a transformation type called "unpivot columns".
In your example, you would select the column with the securities and then upply the transformation "Transform | Unpivot Columns | Unpivot other columns"
This will convert all the other columns into rows.
Thanks Martin_Weiss . I think this approach should work, although still need to navigate my way through this! (I believe Power Query functionality is indeed available to me as a MS365 subscriber). Appreciate the guidance - thanks again!