transposing data

  1. T

    Transposing cell info to new rows, retaining previous info each time

    Hello everyone! I'm working on a fairly large spreadsheet and am trying to transpose various pieces of information from one cell into rows of their own. This is an abstraction from what I'm working with (it is more than 1000 rows long though)...
  2. M

    Promoting one column to become headers whilst keeping data paired

    Hi all, Hi there, Would anybody know how I best attempt this transposing task? VBA or power query?. I need to promote column B to become headers, but the data in column A and C are paired with one another. Data in raw format: Column A Column B Column C Type Category Result ABC Address...
  3. L

    Macro code to transpose specific cells in each row depending on text in that rows "Address" column

    Hi all, I am trying to transpose data in column B and column V of my spreadsheet. I need the cells to basically transpose each row of a spreadsheet in those columns (I need column B to transpose to the cells in columns C,D,E,F,G, and I need column V to transpose to the cells in columns...
  4. S

    Looking For Suggestions (Reformatting/ Transposing Data)

    Hi all, I'm a bit of an excel newbie and am looking for suggestions for any functions/ scripts that will help with my reformatting problem! I currently have a data set with three subheadings. (Number, Name and Fruit.) Currently each row represents a customer with an individual Number and Name...
    • Starstick
    • Thread
    • help in need reformatting suggestions thank you! transposing data
    • Replies: 1
    • Forum: Excel Questions
  5. C

    Transferring data in recurring patern

    Hello, forum. I have an excel sheet with time-series data for several items, where each row represents a different year. Something like this: Item Var 1 Var 2 ... A 5 10 A 6 10 A 8 20 B 1 33.7 B 2 29 B 0 24 ...
    • chumhum
    • Thread
    • auto fill sheets skipping cells transposing data
    • Replies: 5
    • Forum: Excel Questions

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