rows to columns

[Jaye7]

Please refer to attached JPG.

I am trying to change the data in my rows to columns

I have data as per the attached picture in columns B-I

I would like the rows to be pasted to columns as per columns M-Q

so row 1 ends up as the first lost of data in M-Q and row 2 ends up as the second lot of data.

There are numerous rows in my actual file.

 

[pbaldy]

A union query can achieve the look you're after.

 

[Jaye7]

Thanks Paul, sorry I was supposed to post this in the excel forum.

 

[pbaldy]

Ah, sorry. All of the work I've done with automating Excel has been done from Access. I kind of have a thought in my head of how to do it from Access, but not how to do it directly in Excel.

 

[CJ_London]

perhaps you are looking for the transpose action on copy?

https://support.office.com/en-in/ar...and-rows-ed1215f5-59af-47e6-953b-0b513b094dc2

 

[Jaye7]

Thanks for your help, someone on an excel forum provided a script that does the job nicely, I did try transpose but it didn't do what I wanted.

 

[pbaldy]

Glad you were able to find a solution.