Searching for a more efficient way of transposing my data from rows to one row

[FroboLaggins]

I have a tedious amount of these to do (200 files to be exact), some help would be massively appreciated:

Say I have 8 rows of numbers from column A to L, like so:

123456...
123456...
123456...

and so on, but I need to transpose them to this format:

123456...123456...123456...

all in row A

Is there an easier way to do this than individually copy and pasting each row?

Thanks in advance

 

[astout920]

first copy all the data in that column. then go to the row you want to paste, and paste special transpose... after copying the data, hit alt, h, v, s, e and then enter

 

[sandy666]

all in row A

There is NO row A , it can be row 1 or column A

if you want to use the same column A for the result you'll need any vba

something like this?

123456​		123456, 123456, 123456	OR​	123456​	123456​	123456​
123456​
123456​

if so post a link to shared excel file with representative example data and expected result. Use GoogleDrive, OneDrive or any similar.

 

[Twollaston]

so you want to copy A2:L2 and paste it to M1:X1
and then a3:l3 and paste it to Y1:AJ1 and so on...?
Just want to make sure I understand

Be specific about the cells you want to adjust, and what cells to move them to

 

[FroboLaggins]

The example on the right side is exactly how I am looking to present them, sorry about the row naming that was my mistake.
It would be Row 1-8 and Column A-L

 

[FroboLaggins]

There is NO row A , it can be row 1 or column A

if you want to use the same column A for the result you'll need any vba

something like this?

123456​		123456, 123456, 123456	OR​	123456​	123456​	123456​
123456​
123456​

<tbody>
</tbody>

if so post a link to shared excel file with representative example data and expected result. Use GoogleDrive, OneDrive or any similar.

The example on the right side is exactly how I am looking to present them, sorry about the row naming that was my mistake.
It would be Row 1-8 and Column A-L

 

[Rick Rothstein]

The example on the right side is exactly how I am looking to present them, sorry about the row naming that was my mistake.
It would be Row 1-8 and Column A-L

Did you read Message #2 yet?

 

[sandy666]

could you post a link to shared excel file as mentioned in post#3 ?

 

[FroboLaggins]

could you post a link to shared excel file as mentioned in post#3 ?

Here is the google drive link: https://drive.google.com/drive/folders/13P5iMleUMLEOJuRYeb--MXQVa04nHraI

and I have attempted the solution in question 2 but I am completely inept at excel and am finding a lot of difficulty .

 

[sandy666]

post #3 and post #8 contain a word: shared
your file is NOT shared

@post#2

copy your source range (Ctrl+C)
select any free cell out of source range
from the ribbon Paste (option arrow) and select Transpose