transpose fill down data

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...

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...

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...

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...

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...