rows to columns

I'm looking to transpose a spreadsheet that consists of a column with an ID for the whole row of data, followed by data fields listed in a typical column/row setup, similar to the table below. And for background, my particular data set has thousands of rows and about 20 or so columns. <tbody>...

Hi Everyone, FYI, I do not think this is just a simple transpose question. I have data in the form of: Item Attribute Item 1 XXX Item 1 YYY Item 1 ZZZ Item 2 AAA Item 2 BBB etc. I want to reformat my table so that it's like: Item Attribute 1...

Hello I'm quite new to data manipulation with Excel, but have been tasked with converting a report into a more efficient format. The report comes in a format as below (but more fields and much more data (for up to 5000 people) <colgroup><col><col><col></colgroup><tbody> Jon Smith Age 57...

I need help with a macro that will transform the following table: <tbody> Component P/N Rev Qty BUn Description Mfg Name Mfr Part Number 130-158-01-02 <tbody> D2 </tbody> 1 <tbody> EA </tbody> <tbody> Display/System uP,Jabroni </tbody> <tbody> 220-819-01-00 </tbody>...

Hi guys, so I have this massive text file that I need to get into Excel. The files is like this in text: Alaska Southcentral Foundation-Alaska Native Medical 315 Diplomacy Drive Anchorage, AK 99508 Program Information: Program: General Practice Residency 24 Months Program Director: Dr...

I have a table that I extracted from ArcGIS (see an extract of the table below). It features 12 designated sites and within each of the sites there are occurences of up to 63 different feature types. <tbody> NAME FEATURE FREQUENCY Antrim Hills Heather 15 Antrim Hills Scrub 38...

I have a spreadsheet which am trying to transpose data into separate columns. See example sheet below: <tbody> PolicyNo Name_Address Agent No Code Premium 11256 James Cook 2WD PXT 25.50 Line1 Line2 Town 2356 Peter Jones 56TF TDE 25.50 Line1 Line2 Line3...

hi all I have simple question in sheet1 I have all my data and sheet 2 to have the same date but the ROWS should be converted to COLUMNS thanks you very much for any the help

I have a number of contacts with their details on individual lines in Column A like this in Excel 2010, Windows 7: Grounds Maintenance Helper Bob Smith 165 Cresap Charlottesville, VA 22903 E bob@virginia.edu Sports Management Director Jane Woodard 119 Stadium Road Scottsville, VA 22605...

Dear all, I need to print 100's of certificates and want to run a mail merge. However, I currently have a column of names and then the certificates the names are receiving appear in the same row as the name e.g. row 2 has won awards for progress in art and DT and in achievement for Maths and...

I would like to pivot an Excel table using the following INPUT and expecting the following OUTPUT. INPUT table: <TABLE style="WIDTH: 345pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=461><COLGROUP><COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt...

I have a spreadsheet that has a list of products in column A, with date ranges for sales in column B. The way it is now, products with multiple ranges are listed multiple times in column A, and each sale date range is in a separate row, like this: Item 111 | Jan-Jun Item 111 | Sep Item 111 |...

I have an address sheet where they are side by side and in note pad. I want to import them to excel like a standard mailing list, with columns for First Name, Last Name, Address, City, State, Zip, but I don't know how to rearrange the formatting. This is more clearly what the current sheet...

Hi Really stuck with this one - wondering if anyone can help I've got a data sheet that looks a little something like this: 1 2 3 4 5........31 Mary Q1. a e i m q...... Q2. b f j n r...

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