Copying 2 Columns Of Data Into A Single Row While Adding Spaces

Dec 4, 2013

I have two columns D and E that contain dates and values. Column D has the dates and Column E contains the corresponding values.

I need a macro to take all of the dates in column D (it is pulled from a different macro so the length of the two columns varies every time but starts at D2) and paste the first value in W1, the second value in AE1 , and so on (every eight cells).

I need to do the exact same thing with Column E except start at Y1, then AG1, etc (still every eight cells).

I will try to post an example later.

View 2 Replies


Simultaneously Copying Data From Multiple Sheets To A Single Sheet

Jun 4, 2009

I have a workbook containing about 20 sheets. I need to find a way of pasting all the numbers in the A column in each sheet (sheets 1-20) to the last sheet so I get a great big list of all the numbers in the 20 sheets. How would I go about doing this?

Right now I'm cutting and pasting from sheet 1 to my last sheet, then from sheet 2 to my last sheet, then from sheet 3 to my last sheet... Is there a quicker way? The ranges in each of the sheets start at A2 and go down a few cells. Sheet 4 might have 4 numbers in the A column, sheet 12 might have 47, sheet 17 might have 8 and so on.

How would I go about getting all the A columns in the sheets to the last sheet?

I'll throw up a few screenshots if the problem is unclear

View 9 Replies View Related

Copying Data From Multiple Sheets To Single Sheet In New Excel File

Feb 6, 2012

I have an master excel file with 20 sheets with names x,y,z,a,b,c,f,.... Each and every sheet has data which start from Row 7 and Column 2. Now i need to consolidate this data in one sheet in another excel file.

Consolidation should be like

Suppose X sheet has 20 rows and 4 columns of data which starts from Row 7 and Column 2, this data has to be copied and pasted in my new excel file copied on my desktop. Now first 20 rows are occupied in new excel file.

Now code should move on to master excel file Sheet Y which has 45 rows and 4 columns of data which starts from Row 7 and Column 2,this data has to be copied and pasted in my new excel file from row 21, which means Master excel file sheets has to be clubbed to one consolidated excel file.

In All the sheets in Master file Data starts from Row 7 and column 2.

Data range varies row wise in each sheet but column length is fixed to 4.

View 9 Replies View Related

Application.Run - Spaces And Single Quotes

Jun 3, 2009

Ok so I know I can run a function in another (open) workbook by doing the following line:

View 6 Replies View Related

Copying Part Of Cell Which Has No Spaces?

Nov 4, 2013

How to copy part of a cell to a new cell when there are no spaces or specific features to use in the formula. My cell contains a data and time as such: 2013-10-22T14:05:34Z

My hope is to keep the data 2013-10-22 in one column and transfer the 14:05:34 to a new column...if the 'T' and 'Z'

View 2 Replies View Related

Adding Spaces To Beginning Text

Apr 5, 2013

I want to add blank spaces to a cell with text

My cells have up to 14 spaces
If a cell as 1 or 2 characters -I want to add 6 spaces in front of text.
If a cell as 3 or 4 characters-I want to add 5 spaces in front of text.
If a cell as 5 or 6 characters-I want to add 4 spaces in front of text.
If a cell as 7 or 8 characters-I want to add 3 spaces in front of text.
If a cell as 9 or 10 characters-I want to add 2 spaces in front of text.
If a cell as 11 or 12 characters-I want to add 1 spaces in front of text.

View 4 Replies View Related

Adding In Extra Spaces For Post Codes

Mar 2, 2009

I have a table of postcodes and I need to import them into a bespoke application. The aaplication requires them to have extra spaces depending on the postcode i.e.

BS35 2JW - this is fine because it has the maximum amount of characters 8

BS1 2JW - I need to add 1 space

B1 2JW - I need to add 2 spaces

View 9 Replies View Related

Copying Columns Of Data

Jan 7, 2013

I'm currently making a workbook of annual sales lists for my small business. There are separate sheets for each year (2007, 2008, etc.) where column A consists of a list of customers for that year and the next 12 columns include sales for each respective month.

The issue I'm now facing is in trying to create a new "master" sheet of sales (month-to-month) for every year (2007-2012). The problem I'm having is transposing the sales data for each month from the previous sheets. Why I'm having trouble is this new sheet will be for every customer we've ever had whereas the past annual sheets were merely for customers in those specific years.

Thus I have annual sales sheets of 800 some customers while the final sales sheet will be nearly double that. What I've been attempting is to match the customer name from the master sheet with a specific year and if matched, transpose the monthly data associated on that yearly sheet. The formula I came up with works to a certain extent and then seems to fail because the customer difference gets lost in translation. I'm doing something wrong so that it's not looking for a match out of the entire 1600.

Here's my formula I'm trying: =IF(ISNA(VLOOKUP($A2, '2007'!$A$2:$A$883, 1, FALSE )), "", '2007'!B$2:'2007'!B$883)

View 2 Replies View Related

Two Columns Data In Single Column Conditionally

Jun 7, 2014

I am having data in two columns (A & B ). Now I want to get the data in the single column(column C) . Here column A(Name) & Column B(Mobile No). it is something like below.

Here is my input data:

I want to get output results like below in the column C

View 7 Replies View Related

Copying Out Data Columns Of Different Lengths?

Jun 25, 2013

I am half way through writing a bigger macro, but am stuck at this stage.

I need to copy from a block of data as shown:

However, this column varies in length each time, and I only want to copy down to where the entries stop.

I also only want to copy W1:X6, and columns Y, AA, AB, AD (but only down to the end of the column)

I've tried using the End(xlDown)).Copy function, but obviously this doesn't work with the block up the top and the gap between the block and the columns

View 4 Replies View Related

Adding Data From Multiple Columns Into One, Data Seperated By Commas

Mar 27, 2009

Using =A7&","&B7 to add data from two columns into one, separated by a comma. What about multiple columns, still separated by a comma? See Example in attachment.

View 2 Replies View Related


Dec 23, 2006

123569LOC23 is in one cell and I am trying to copy the "LOC23" to a new cell. However, the amount of digits vary: LOC23, LOC1,LOC15 etc all the way down the column.

View 9 Replies View Related

Moving Data From Single To Multiple Columns And Merging?

Dec 16, 2012

Current Data:
File 1:

Each set of data is listed in either two or three rows




The goal is to move them to separate columns (rows can be 3 or 2 for each data set, and may or may not be separated by space/additional row)

File 2:

Has a common field 'ID' as that of File1, does not have Date, and Filename, but has a new field 'Detail' (already in the expected format)


ID Detail

The goal is to merge properly formatted data from File 1 to File 2


ID Date Filename Detail

View 14 Replies View Related

Moving Data From Multiple Columns To Single Column

Mar 28, 2012

in moving data from multiple columns to a single column. I have attached a sample image from an excel file which details the requirement. The first column contains a qualifier, that should remain constant when the data from columns B to the end move to a single column "B". The number of columns for each row is different, however, there is a maximum number, say 25. As mentioned in the image, when the data from columns B to the end is moved in to column B, column A is retained fixed, to the original value, and the original data below it is pushed below. Any pointers to how this can be achieved by VBA or without VBA?

View 6 Replies View Related

Move Data From Single Column To Multiple Columns

Feb 29, 2008

I saw this thread from June Cut & Paste Macro: Move Address From Column To Row and I think this what I would like to have my macro do. I have one column which is copied and pasted as text in excel and there is several blank rows.

I attached the spreadsheet example - it has 40 lenders, with the top row being the lender name (A1), followed by address(A2), city-state (A3), two blank rows(A4-A5), lender type (A6), approved date (A7), one blank row (A8), lender specialty (A9), telephone (A10) , e-mail address(A11) and two blanks rows (A12-A13) and A14 starts over again. For this example there should be 8 columns and 40 rows (lender name, address, etc...). As I mentioned I think the previous thread's macro would work with some minor tweaks. I couldn't figure out the best way to handle the blank rows and or remove the blanks and what to add or take out of the macro code.

View 2 Replies View Related

Keep Functionality When Adding New Columns Of Data?

Jun 26, 2013

Each week I get new weekly data-metrics. I have a series of formulas that figure LAST 4 weeks average, LAST 8 weeks, etc etc. How do I drop in a new week of data and have my formulas adjust? For instance, my formula figures last 4 weeks average of May Wk 1, May Wk 2, May Wk3, May Wk4. Now it is June Wk1, so I want to figure (without changing any formula) May Wk 2, May Wk3, May Wk 4, June Wk 1.

View 1 Replies View Related

Adding One If There Is Data In Adjacent Columns

Nov 20, 2008

I want to total cells that have data in them across a row. I have a name in Column A and then in Columns C-Z I have data. In Column B I want Excel to scan across cells C-Z and if a cell has data in it (it will be text) I want it to add one to the total in cell B. Would CountIF do this with text involved?

View 7 Replies View Related

Copying Filtered Data Columns To New Spreadsheet

Oct 14, 2008

I have a spreadsheet with two tabs (Customer Survey Data) and (Customer Rollup). The data starts on line 5 (headers in rows 1 thru 4) and is found in columns B thru J. In column B I have dates with no blanks. In column C I have customer names - no blanks. In column J is are the customer comments - not all customers made a comment so there are blanks.

I created a macro that autofilters the data to show only those entries within a specific date range (dictated by dates found in L1 and L2 - begin and end dates respectively) by column B (no problem with this). The macro also auto removes all rows where there are no comments (column J = no blanks). This leaves me with only those surveys recieved within a specied date range that have comments.

Here is my problem: the Customer Rollup sheet is the finalized report. I need to copy only the customer names and their comments into the finalized report. The following is the macro I put in which only half works and I have no idea why. It copies the names fine...but then only copies the first comment.

Oh yea...I don't want to copy the WHOLE column...only from the first visible row down to the last. Btw...I put a lot of notes for myself...I capitalized the notes where I think the problem is...Any suggestions on how to fix it or why it just doesnt seem to work like it should?

View 5 Replies View Related

Moving Data Cells From Multiple Columns To Single Column

Nov 14, 2011

I'm trying to work out how to take all cells with data from multiple columns and stack them in a single column.

Here's the history...

I have multiple part numbers in single cells in column A. I perform a text-to-columns function. The resulting part numbers spread across multiple columns (say, B through K). Now I need to get all the part numbers, in their own cells, stacked in column A for one continuous list of single cell part numbers.

Is there a VBA option for cutting only the data cells from Column B-K and pasting the data at the bottom of column A while avioding blank cells?

View 4 Replies View Related

Excel 2010 :: How To Take Data From Multiple Columns And Add Them Onto Single Column

Mar 8, 2013

I have a long list of data with many columns and I'd like all the information to be in one column without manually copying and pasting each column and adding to the first column. The data has different amounts of rows and columns as well. An Example is below. I'm using Excel 2010. Is there a formula or something for this? This isn't the data I'm using but just an example since I do this frequently.

Data Looks like:




Would like to look like:








View 5 Replies View Related

Adding Columns To External Data Table?

Sep 11, 2013

I have a External Data Table, but I wanted to add a extra column to it for comments. I just need to be able to write down what I did with that particular order or things like that. I did make a column, but the problem is whenever I update the table the comments column fields stay static I mean they don't move with their row. So it ends up the comment belonging to a row is now on another row.

is there a way I can tell excel to move the cell with the record or something like that.

View 2 Replies View Related

Excel 2013 :: Presenting Data In Different Columns In Single / Pivot Graphic

Jul 24, 2013

I have 2 columns with a list of competitors (competitor 1 & competitor 2) involved in a negotiation + the price/value of the negotiation. Each line represents a negotiation with a value in numbers & the names of the 2 main competitors involved.

I have around 150 lines in the original file and would like to show in a graphic what are the competitors that we regularly find in the negotiations and what is the value of the negotiations they are involved.

The problem is that there is no main competitor so i can find the same name in any of the 2 columns and i cannot make separate graphs for each column because if i do so i duplicate the value.

Is there any way that aggregate this info into a single graphic/pivot graphic? Im using excel 2013

View 2 Replies View Related

Summarize Data From Columns In Multiple Sheets To A Single Datasheet Of Rows

Jun 19, 2014

I need a macro that will take hours by day (columns) by service (rows) per client (sheet) and summarize the data into one database of rows containing client, service, date, and hours. The "Summary of Charges" should only include service hours > zero. I am attaching a sample file. I have little to no experience with vba so I don't even know where to begin. I can copy code.

View 4 Replies View Related

Macro To Copy Data From All Columns Containing Header To A Single Column In Workbook

Apr 11, 2014

I am a macro newbie and I think this is beyond me.

I've been trying all morning with no success to make a macro that will copy data from all columns of one workbook containing specified header text to a single column in a different workbook.

So for example, I've got a workbook called coupon barcodes that has multiple tabs for each person redeeming coupons on sheets 2-88 (sheet one can be skipped) and some of the columns are labeled "voucher 1" in cell A4 or B4 or C4 etc. with a list of all the coupon barcodes that customer redeemed below that. I want all of the data from all of the columns in this workbook that have the header "voucher 1" to be copied and pasted into one column (order doesn't matter) also labeled "voucher 1" in another workbook I have open called vouchering database.

There must be a way to do this that is easier than searching the internet all afternoon again

View 3 Replies View Related

Excel 2010 :: Copying Data Form Columns To Rows?

Mar 27, 2012

I need something that will take data from columns in one Spreadsheet and put in difference cells in a row. I know this could be done with recording a macro but the number of column will never be constant.

Below I attached examples of the Spreadsheet

Financials SpreadSheet
Need to have the data in column B to F put their respective cells in row in the
Master Spreadsheet
So we would have 5 rows.

Excel 2010ABCDEFGH5Job Number17542000250030003500Total6Date Booked01-Mar-1215-Mar-1215-Mar-1223-Mar-1223-Mar-127SalespersonJames ThorntonHoward StandenHoward StandenIan BullimoreSylvia Walton8AdvertiserNestleTalkTalkLloyds BankSkodaHonda9ProductNature ValleyBroadbandMortgageApril


View 6 Replies View Related

Conditional Copying To Single Row - Normalization?

Nov 14, 2012

I have data like this:

James English
Bea English
Bea Math
Pat English
Sarah Math
Sarah Geography
Sarah Art

What I want is

James English
Bea English Math
Pat English
Sarah Math Geography Art

I have ~350 rows of subjects. Is there an efficient way of doing this? At the moment I'm cutting and pasting.

View 6 Replies View Related

Concatenate Multiple Columns With Spaces

Jun 21, 2008

I've searched quite a few times for Concatenating Multiple Columns and ones for Concatenating with Spaces.

I've found solutions that say use

=concatenate(A1, " ", B1)

or the VBA equivalent

I have at least 15-20 columns which I wish to concatenate.

Is there an easier way than to type for all 15 columns?

=concatenate(A1," ", B1," ", C1,....)

Also, the number of columns of each row vary

View 9 Replies View Related

How To Remove Unwanted Spaces In Columns

Jun 8, 2013

In Column A, I have several rows of data. Some cells contain numbers and some contain text and some are blank. In Column C, I only want the numbers in Column A. I do not want the text and I cannot have any gaps in the column.

So for example:

Column A: row 1: 456 row 2: 789 row 3: text row 4: text row 5: 398 row 6: text row 7: blank row 8: 124

in Column C I need:

row 1: 456 row 2: 789 row 3: 398 row 4: 124

View 10 Replies View Related

Adding Numbers In A Single Cell

Mar 31, 2009

What is the function to add numbers in a single cell to show only a single number. I know it can be done but do not know the quick function to do it.

View 10 Replies View Related

Adding Text To Single Column?

Apr 4, 2012

I simply have an entire column with random things in it that I would like to add "www." to the beginning and ".com" to the end. I am very new to excel and I am sure there is an easier way than going through it manually and entering it.

View 6 Replies View Related

Copyrights 2005-15, All rights reserved