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?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td]

123456​

[/td][td][/td][td]123456, 123456, 123456[/td][td]

OR​

[/td][td]

123456​

[/td][td]

123456​

[/td][td]

123456​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

123456​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]

123456​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table]

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?

[TABLE="class: head"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]

123456​

[/TD]
[TD][/TD]
[TD]123456, 123456, 123456[/TD]
[TD]

OR​

[/TD]
[TD]

123456​

[/TD]
[TD]

123456​

[/TD]
[TD]

123456​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]

123456​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]

123456​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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