transpose fill down data

  1. N

    Transposing multiple tables

    I have a worksheet that has 5 tables on it and all of them are transposed with the weekly breakdown going by column instead of by row. I'm trying to find a way to (easily) transpose all 5 tables so I can pull the data from them into a combined table more efficiently. I'd like to avoid having...
  2. M

    How to transpose then move cell locations so it prints correctly

    Hi All, I don't know what keywords to search online for, so I figured I'd ask here. A co-worker of mine is old school and she takes data from excel, then has to manually hand-write customer information on separate sheets of paper to submit rebates to vendors. I only listed 4 examples below but...
  3. S

    Convert columns into rows with a repeating attribute

    Hello, I am trying to turn the following row (and similar rows); Name Age Gender Tel Number John Smith 32 Male 09876 345432 into a number of multiple rows; Name Attribute Name Attribute Value John Smith Age 32 John Smith Gender Male John Smith Tel Number 09876345432 Any help much...
  4. 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...
  5. J

    Transpose Rows and Fill Down Static Data

    Hi. I am working with two columns of data. Column A is a style number. Column B is a size run for that style. I would like to copy/transpose the size run into a vertical list of sizes - one size per row - and have the style number fill down next to each size. Transposition could take place on...

Watch MrExcel Video

This Week's Hot Topics

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
Top