Move data from one sheet to another.

Occasional Visitor

DesiredDesiredSource dataSource data



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.

1 Reply

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: