Mar 17 2022 11:59 AM
I could not upload the excel file. I have 2 screenshots attached.
The source data photo is the data i have and I want to move the data into a new sheet so it looks like the Desired photo.
I have 85 people like the examples I provided and I have 12 months of data like I provided.
I want all of them in one sheet with each month's data in adjacent columns.
Thanks for the help and keep making wonders.
Mar 18 2022 08:06 PM
Hi @SKoneti
If you run a recent version of Excel on Windows a Power Query option in the attached file where Sheet1!A1:AZ6 in named Data. Output as below: