moving data coloumns to rows

[Annie D]

Hi having this problem, trying to move large sets of data from columns into rows, currently looks like this;


-- removed inline image ---



Any suggestions would be great? ive tried transpose and didnt work as the data set is too large.

Annie

 

[Greg Truby]

Annie,

Welcome to the board. Your images come across as just red "X's" Have a look at this thread:

http://www.mrexcel.com/forum/showthread.php?t=204962

 

[Annie D]

hi thanks greg,

here they are again hopefully this works;

I want to change this ;

http://i1134.photobucket.com/albums/m619/annied2/excel2.jpg

To look like this;

http://i1134.photobucket.com/albums/m619/annied2/excel1.jpg

A

 

[Burrgogi]

hi thanks greg,

here they are again hopefully this works;

I want to change this ;

http://i1134.photobucket.com/albums/m619/annied2/excel2.jpg

To look like this;

http://i1134.photobucket.com/albums/m619/annied2/excel1.jpg

A

I don't see much difference in your 2 screenshots other than the numbers at the top row have been moved. Hi Annie, are you by chance trying to do a transpose??

http://www.timeatlas.com/5_minute_tips/general/how_to_switch_excel_columns_and_rows

How to transpose

 

[Annie D]

hi Burrgogi,

if you look at the second screen shots you will notice that the location numbers not only moved down the coloumn but also the corresponding data set under location 17 has moved too.

 

[Burrgogi]

I can't edit my post above as the time limit has expired.

Annie

I just read your comment above. Data set is too large? Interesting. Unless there is something wrong with your computer, Excel should be able to transpose large numbers of columns to rows etc. If you can provide some more specifics as to where those current values are supposed to be placed, one of us here can help you further. For example, please be specific in your cell reference. e.g. transpose cells C1 thru AA1, placed in B10.

 

[Greg Truby]

Annie,

What's your experience level with VBA (writing macros)?

 

[Annie D]

Hi burrgogi,

Thanks for your reply.

Im trying to move column cells b1 to b172555 to row A12555. does that make sense???


Hi greg,


My VBA level is very basic. Ive only ever used macro to record an action thats about it.

 

[Greg Truby]

Im trying to move column cells b1 to b172555 to row A12555.

Congratulations! You're the first person I have personally seen that wants more than the new limit of 16,384 columns. Not sure how you woulda survived with the mere 256 columns we lived with up until 2007.

So no - ya cain't get there from here.

 

[Burrgogi]

Hi burrgogi,

Thanks for your reply.

Im trying to move column cells b1 to b172555 to row A12555. does that make sense???


Hi greg,


My VBA level is very basic. Ive only ever used macro to record an action thats about it.

OK, Annie - try this:

Sub Transpose_RowB()
'
' Test Macro For AnnieD
'
'
    Range("B1:B172555").Select
    Selection.Copy
    Range("A12555").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=True
End Sub

To get this macro to work, you will need to insert this into a module. You can either save it into your personal.xlsb or int the worksheet that you're trying to perform the transpose operation.

With your workbook open, press Alt + F12. This will open up your the VBA editor. On the far left column you will see the name of your current workbook under VBA project heading. Your workbook will be shown with all the worksheets and the last one should say: "This Workbook".

Right-click on it. > 'View Code'

Now in the right hand side, you should see a blank window. Copy and paste the macro that I provided for you above.


Nevermind: I just saw Greg Truby's posting. I didn't realize there was a limit of 16,384 col.