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