transpose data

Hello, I'm looking for some help with transposing a data set I have. All the data is in one column like this.... Company 1 Address 1 City 1 Phone 1 Email 1 Company 2 Address 2 City 2 Phone 2 Email 2 Company 3 Address 3 City 3 Phone 3 Email 3...

Hi there, Im trying to create a Macro which can do the following: Start selecting from a1 till blank column and coming down till blank row cell by cell , select the all above values, copy them and paste them by transposing them AFTER tWo blank columns, carry on doing this procedure and...

Hi All, I have 2 sheets on the first sheet is the following first 3 columns 1. Apple Yes 2. Banana 3. Pear Yes 4. Lemon Yes 5. Grape 6. Orange Yes What I am looking for is on the second sheet I need a formula to only bring in the ones that have a Yes next to them so the second...

Hello, I track operational metrics in Excel 2007, and for ease of forecasting, this is laid out with descriptive columns then time frame columns. 72 columns across in total. ~5,300 rows. Sample below. Each data row has 6 columns that identify the: A Metric (ie Received Units) B Ledger...

I have a large dataset of annual information for three cities and an average broken down by month with according data for various categories generated vertically. For chart creation and ease of reading, I want to show this horizontally and ordered differently. Below is a short example of what I...

Need help to write a macro that will take data from "original data" and transpose it. The length of the group in the name column is unknown Original data Name A 5 A 8 A 2 b 7 b 33 b 44 c 9 c 3 c 77 Transposed data a 5 8 2 b 7 33 44 c 9 3 77 Thanks Tody

<COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2560" width=70><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2304" width=63><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1243" width=34><COL style="WIDTH: 33pt...

<colgroup><col><col><col><col><col span="8"><col></colgroup><tbody> Query View Code Dist RSM Brand1 Brand2 Brand3 Brand4 Brand5 Brand6 Brand7 Brand8 Brand9 Brand10 320002 Ali Traders Asser 2 3 5 6 7 8 9 10 4 66 </tbody> <colgroup><col style="text-align: center;"><col...

Hi all, I am using Excel 2010. I have a set of data as shown in the image below: I need to reformat the data so that I have ONLY 2 columns, namely "RN" and "PKG REV". Thus I need all the figures relating to "RN" to fall into the new "RN" column and same thing for "PKG REV". Is there a way...

Hi! I have a spreadsheet full of data. The first three tabs are considered summary data and the 4th is where the data is pasted from. Data output comes from a SQL query (already made). The output comes out vertically and every cell is linked to the 4th "Data Paste" tab. Yet, I have a request to...

I'm working in a sales summary file, and I'm using the following formula: {=(SUMPRODUCT(TRANSPOSE('2013 Market Matrix'!$U$17:$BJ$17),'Top 40C by Month vs PY'!E$8:E$49))} The purpose of this is to take sales dollars from customers and run that against a series of percentages to determine sales...

Having read what seems like hundreds of forum posts about using a macro to transpose data from columns into rows, I still haven't managed to get my macro to work. I need to go from this: <tbody> 1 2 3 4 Category A Record 1 B C D E Category A Record 2 C D E Category B Record 3 C A...

Hi, I have data that looks like this: Cust no. cust name item Jun Jul Aug 1 a x 1 2 3 2 b y 2 3 4 3 c z 3 4 5 But I need it to look like this: Cust no. cust name item peroid Data 1 a x Jun...

I have sales figures of 100 companies from 2003 to 2010 i.e. Company 1 03Sales 04Sales 05Sales --- 08Sales Company 2 03Sales 04Sales 05Sales --- 08Sales ' ' ' Company 100 03Sales 04Sales 05Sales --- 08Sales I wanted to transpose this data...

Hi, I got some work in Excel which is briefed as below: INPUT: Company names, web address and Categories* * Categories means to which single/multiple category the company belongs to. i.e. a company can be part of A1 only or it could be a part of A1, A2, B5, J13 etc. The categories comes in...

Below is my input. PROD AT1 DESC AT2 DESC AT3 DESC AT4 DESC fan 1 at 2 sd 6 tf 6 hg book 9 td 3 hg 4 jh Look 7 kj 5 ih OUTPUT SHOULD BE...

I am sure this is a simple fix for the experienced Excel user... and I apologize if this is explained in other threads. I could not find what I needed after two hours of searching. Anyhow... here it is... I have a file that is over 400,000 fields by two. A small portion of the file looks...

Good morning, I submitted a thread for this previously but didn't have the proper elements in it to get help. I have a data set that looks similar to the RAW tab in the following file http://www.box.net/shared/fpgqyv9ok3nghx9foqlq What I need is a formula or a macro to put the data in the form...

Hi, i have data in this format. <TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=64><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext...