transpose macro

  1. B

    Macro For Transpose Paste Into New Rows (Modified Example) to modify a VBA code.

    Hello, Thank You all for Your huge help solving lot of issues and helping out. My first example with this issue was in the post here. I got two response for fixing this issue. I thought about how to change code into 1st of the answers (given by Rick) to make it work for situation stated...
  2. B

    Macro For Transpose Paste Into New Rows

    Hello Excel Community. Once again I got a problem. This one is similar previous one, but at the same time different. <tbody> Original: <tbody> A B C D E F G H I J K L M 1 Name Color 8 10 12 14 16 18 20 22 Price 2 T-Shirt White N $10 3 T-Shirt Black...
  3. E

    Transposing large data set

    Hi, I have a data set in Excel that is 416 columns by 5433 rows. I want to swap the columns and rows but cannot do this using the transpose function as an error message stating that the copy and paste areas are different sizes keeps coming up. So what I have is: Sample 1...
  4. H

    transposing one column into rows 52 columns wide

    Hi I have answers to a survey from about 140 people listed in one column. The survey is 52 questions long. I need to transpose the data, so the first 52 rows in the column are transposed into one row 52 columns long, and then the next 52 rows are transposed into the row below the first...
  5. M

    n00b to VBA needing assistance

    Hi All, I am new to the world of VBA, and have starting to feel a little frustrated with something I thought would be simple enough to do, but isn't working the way I would have hoped. I have a large table of data with three columns. The first column consists of an ID value incrementing from 1...
  6. M

    How do you transpose X number of sequential rows into their own separate columns?

    Hello everyone! I am new to VBA macro coding and could use a little assistance. Issue: My current file has all data in one column "A". How do you transpose X number of sequential rows into their own separate columns? Possible Solution for what I want: A VBA macro that solves the issue. My...
  7. J

    table transpose help

    i have a report that is getting to wide in excel to be manageable. it is a "punch-list" of sorts that lists known issues with various stores. it lists 10 issues per location, and each issue has 4 columns associated with it, so I am now 40+ columns wide. if anyone could help with a macro that...
  8. T

    transpose data of duplicate cells

    the source is like this. col1 col2 220 bat 211 van 223 fan 220 cat 211 tin I like the result to be like col1 col2 col3 220 bat cat 211 van tin 223 fan Can anyone suggest me a macro for this. I have 10,000 rows like this. thanks
  9. M

    macro to transpose column data to row data and jump to next instance

    I am trying to create a macro that will copy the data in columns AX1:HM1 and transpose starting at AW2. It would then jump to the next instance in AW where there is data and again copy the data in that row for AX??:HM?? to AW??. I managed to record a macro that does everything but loop to the...
  10. H

    Need VBA Macro to transpose variable rows to col.

    Hi VBA Gurus, I need some help with a VBA transpose function. The number of rows to transpose varies .. but the common marker is "Exited Site".. Would ideally like to see the results in a new sheet here's what the current (input) data looks like .... <TABLE style="WIDTH: 132pt...
  11. R

    Transpose range

    for the life of me I cannot remember how to shorten this Sheets("MW Forecast Calculation").Range("calcday1").Copy Sheets("Next Day").Range("NextDayTempRH").PasteSpecial Paste:=xlPasteValues, Transpose:=True I have the below but I cannot remember where (if) to put transpose? Sheets("MW...
  12. T

    Help needed to transpose large amount of data

    Hello all I'm quite sorry to introduce myself by asking for help right away, but I am quite stuck with a problem at the moment. I have to analyze some data wich is extractable from a database only by PDF lists (a genius must have been at work when he drew the specs for it). I have three PDF...
  13. L

    Transpose rowsg keeping heading in column a and data in column b

    Dear Forum I have an excel spread sheet with several rows of 265 (9A-IV) columns each with a heading. I would like to transpose the worksheet columns so that the heading is placed in Column A against the corresponding that is placed in column B. For example <TABLE style="WIDTH: 192pt...
  14. C

    How to transpose only populated cells?

    Hi, I'm working in the fashion business :cool: I have a large database with data at style level (gender, product type, price...) and quantities size by size (s, m, l, xl) Typical data would be: women, sweater, $30.00, 0, 10, 15, 13, 6, 0, 0 for the following column headers: gender...
  15. A

    Transpose to matched names

    Hi. I have 2 workbooks where I need to transpose data from 1 workbook to another. It was suggested that I use a pivot table and then a lookup table, but I am not sure how this works with my workbooks. Workbook 1: <TABLE style="WIDTH: 252pt; BORDER-COLLAPSE: collapse" cellSpacing=0...
  16. N

    transpose macro

    i have tables in one sheet ie 1st is at A1:F48 2nd A51:F98......so on till F52000, all tables have same fields and same amount of rows and coloumns, i want macro to transpose all these tables in same sheet or another sheet. please help
  17. D

    Transposing data linked to a main part number

    Hi all Hope someone can help, Column A is the main item Column B is the item description Column C is the items linked to the main item the first 3 rows are correct and are how I need the linked items displayed (transposed, columns merged;separated with a semi colon, pasted in the first row of...
  18. J

    Transposing Data

    Hi Guys, I have a bit of a problem transposing some data, it might be really easy, but I cant think of an easy way around it (but i am only a novice excel user) I have lots of data like this, so an simple method would be great (maybe a Macro) I want my Data to look like this: <table...
  19. P

    Need a Macro to transpose data

    Hi, I need to transpose data formated as follows: <TABLE style="WIDTH: 351pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=468 border=0><COLGROUP><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 2986" width=84><COL style="WIDTH: 48pt" span=6 width=64><TBODY><TR...
  20. powerjak

    VBA Code Needed to Reorganize Dated Columnar Data to Sequenced Row Data

    Raw data is Comma Delimited text file organized Column-wise. For each daily date (oldest to newest), there are various weather data in adjacent Columns. I am only interested in two Columns of data ... the MAX & MIN Temp for each day. I need to process the data and reorganize it Row-wise. One...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top