transpose rows to columns

  1. B

    Transpose from 1 sheet to another

    Hi All, i am looking to make a laptop register for work, what i want is to past the laptop specs into a sheet and hit the cmdbutton. this will then transpose it from vertical to horizontal. i need it to enter into sheet2 on the next row down. at the moment i can only get it to overwrite the...
  2. G

    Help to Transpose Data from rows to Column based on the same Value

    Hello, I have some data here that I would like to transpose based on the same value in between underscore of column D: ACD1NumberOrder...
  3. D

    [Power query] Transpose uneven data and combine multiple occurences by delimiter

    So i got some rough data from an SQL, it is in JSON and it's poorly formatted. I've somehow managed to format it almost how i want it, now i'm just limited by my skills and i can't seem to find anyone with a similar issue. I've tried several things, split by list, group, transposing you name it...
  4. L

    Transposing from Column to Row

    Hi all - I have a sheet (titled 'QRR Template') with multiple columns that users will be populating. On a second tab ('Extract for email'), there is a Command Button where if clicked, it copies the user data from the 'QRR Template' tab and transposes the data from row format to column format...
  5. W

    Macro for flexible 'Text to Columns'/Transpose rows to columns/copy down cell data?

    Hi everyone, I've unsuccessfully tried to leverage the coding from other threads for what I need completed. Basically I have a very long spreadsheet of account numbers in column A and email addresses in column B. The email addresses are all grouped together in one cell, separated by a comma, and...
  6. K

    Help needed to transpose range of data to the next blank row in another worksheet

    Hi, I need help with Visual Basic. I only know how to record macros (which results in very long scripts), and need help with this code. Background info: I have 2 worksheets in this file: 1 – Calculator (which I will key in some numbers). 2 – Summary (which, at the click of a button, I want the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top