Forum Discussion
Reformatting/Changing raw data summed in column/YTD format to row format
I get my raw data from a payroll provider in this format that is YTD with the months across the columns/ summed across columns. I previously received my raw data the same way I did in the table to the...
Hi and thank you for helping out.
This file is a sample with random data. But it comes in that data set format on the left with the table the end result I need it in.
It’s a little busy for me to power through the Power Query LinkedIn Learning course and I really want to understand it so I’m going to make time for it now but I need this data in this format for now.
This file is a sample with random data. But it comes in that data set format on the left with the table the end result I need it in.
It’s a little busy for me to power through the Power Query LinkedIn Learning course and I really want to understand it so I’m going to make time for it now but I need this data in this format for now.
Generate by Power Query table is here
entire columns with source data are named as Range. Idea as in previous post.