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:

 

Screenshot.png