How To Add 2 Columns Into One Column
Mar 7, 2014I wondering how to put together for example column A and column B to one column? is it possible?
View 4 Replies
ADVERTISEMENT
Excel 2010 :: Move Part Columns Of Data From 6 Columns To Form 1 Large Column In Column A?
Jan 31, 2013I have a large spreadsheet converted from pdf whose data still appears in A4 reading format.
I need to move part columns of data from 6 columns to form 1 large column in column A.
For example, move range B8 to B76 beneath range A8 to A76 and range C8 to C76 beneath that etc, page by page working through all 270 pages !
Also need to delete unnecessary 'page headers' throughout as in rows 2-6
Convert Column B As Multiple Column Titles And Move Data In Column C Into New Columns?
Jun 30, 2014I have a excelsheet that looks like this:
Column A | Column B | Column C
Los Angeles | Fire Dept | 3
Los Angeles | Health Services | 12
New York | Fire Dept | 8
New York | Health Services | 22
New York | Internal Services | 100
New York | Public Works | 7
Chicago | Health Services | 15
Chicago | Public Works | 56
Chicago | Social Services | 4
And I am trying to make it look like this:
Fire Dept
Health Services
Internal Services
Public Works
Social Services
Los Angeles
3
12
New York
8
22
100
7
Chicago
15
56
4
Column Fill Colors In A Column Chart When Some Columns Are Hidden
Jul 13, 2014When I hide columns in a column chart the different fill colors I used on specific columns no longer show up with the colors I originally had. Is there a way to maintain the proper sequence of column fill colors even when some columns are hidden?
View 1 Replies View RelatedFrom 1 Column To 3 Columns
Feb 2, 2013I have 1 column like below:
AAA
999888
BBB
1111
BBB
2222
AAA
999777
BBB
3333
AAA
999666
BBB
4444
CCC
Doit
...
1col.PNG
...
Consider above up to a few thousand rows.
I want to convert it to below 3 column table with rows from an AAA to the next AAA line:
AAA BBB CCC
999888 1111
999888 2222
999777 3333
999666 4444 Doit
3cols.PNG
according to below pattern/rules: 1. there are 3 types of headers: AAA, BBB, CCC. Next line after them are their corresponding values.
values of AAA and BBB (that is to say, next lines after them) are not null.
ex:
AAA
BBB
or
BBB
CCC
cannot be seen. They will always have values after them.
CCC column header may not be seen between 2 AAA entries as in the example above. From one AAA to the next AAA if there is no CCC, the new column of CCC will be empty for that row. What is the way to perform this in excel (any version 2007,2011 etc) or perl, shell, awk etc are all fine as well..
Column 9 To Be The Sum Of Columns 3, 6, 7, And 8
Feb 5, 2009I need column 6 to show 15% of column 5, then I need column 9 to be the sum of columns 3, 6, 7, and 8. I just can't figure out how to do this. What I'm trying to do is take a wholesale price, get 15% of it to figure for shipping, then add the wholesale price, shipping charge, a drop ship charge, then my Paypal charge together so I can see what I am paying to ship a specific item...then I can figure out what to charge.
View 9 Replies View RelatedMultiple Columns In To One Column
Aug 12, 2014I have lots of columns that need to be stacked into a single column Ex: put all data in column A,B, C, then below column D,E, F then below G,H,I Data in column A can be same as in column D or Column G All columns are in the one sheet.
CORE
BEG
NEXT
CORE
BEG
NEXT
CORE
[Code]...
Desired Records
Column A Column B
A1
123-183
A2 567-603
SUM Columns B And C If Column A Starts With One?
Mar 11, 2014Column A has numbers starting with 1, 2, or 3 and Columns B & C have various amounts. I would like to get totals or columns B & C for Column A numbers starting with 1.
Tried a few things including SUMIF(A:A,"1*",B:C) with no luck
Delete All Columns If Value In Row 2 Of That Column Is X?
Aug 13, 2014I'm looking for the correct way of deleting columns based on if row 2 has an x in it..
I have two versions that I tried but I am pretty sure there are faster ways of doing it, I don't quite know how to delete all the columns at once.
[Code] ......
The first version doesn't work for some reason and the second column works but is a slow loop, what to do to make this faster?
Splitting One Column Into Many Other Columns
Dec 22, 2007I need a macro which place chosen parts from one column into another column.
For example I have following text in column E:
Column E
Flugschneise {f}
ringsum
(total) im Arsch [vulg.]
mutterseelenallein
Geld und Gut
Pensum {n}
*chosen content not always at the end of a cell!
Now i need a macro which puts chosen content from Column E to Column F or Column G. For example I want that all “{f}s” should be deleted from column E and put into column E. Or I want all {n} to be deleted and placed into column F. Or I want all [vulg.] to be deleted from column E and put into column G. If column F or G already consist of text then the new text( {f} or {n} or [vulg.] ...) should be added to the existing text but separated through a separator like comma or semicolon …
It means that the macro is each time fed with information about what to delete from which column and where to put it. It would be cool if a simple msg box would ask for the needed information.
Sum Column If Criteria In Other Columns Are Met
Sep 10, 2009I am trying to create a formula that will sum up a value in one column if certain critieria residing in other columns are met. I have attached a sample and the criteria.
View 4 Replies View RelatedInset 2 New Columns In Next Available Column.
Sep 30, 2009I have had a search around but cannot find exactly what I'm looking for. I have a worksheet with data from B5-E10 and G5-J10. I need a macro which will insert two columns after column E. So then it would push what was in G5-J10 to I5-L10.
The macro would need to look for the blank column (column F) and then insert two columns before it. The columns will be constantly changing so that why it needs to look for that blank column. After they have been inserted would it be possible to give the columns headings such as 'New column 1' and 'New column 2' in row 4.
Insert A Column Every X Columns...
Nov 25, 2009I am looking for a VBA code (or alternatively a way of doing this in normal Excel) that can let me insert a column every X columns (for example every six columns).
Ideally I would want a code that can let me insert a specific column (the same) every X columns, but a formula that inserts a blank column every X columns will hopefully do.
Add Two Columns Together And Then Divide The Sum By Another Column
May 11, 2009I may not even be calling it the right thing. but let me explain what i'm looking to do. i've got three columns on a spreadsheet and i need to be able to add two columns together and then divide the sum by another column. so something like this:
4+4/636 = 79.5
d2+f2 (divided by) h2 = 79.5
Inserting 2 Columns After Each Column?
Apr 23, 2012I have data in 4 columns, A, B, C, D. Each column has 5 rows of data. I want to write a macro to automatically insert 2 columns, after each column in original dataset.
View 8 Replies View RelatedAdd Column And Sum All Occupied Columns To Right?
May 23, 2013I want to add a column and sum all occupied columns to the right I have tried the code below but the results I get in the cell is this: =SUM(F21:G21)+lc
'Move Header
Columns("F:F").Select
Selection.Insert Shift:=xlToRight
[Code]....
Using COUNTIFS On 3 Different Columns And Then Need To SUM 4th Column
Jun 27, 2013I have written this formula below. I do not know the correct part of this formula that will add the numbers I have in Column AB2:AB552 (bold below). As it is, this formula is counting the number of cells in that range that has numbers in it, but I need it to total those numbers as my final result.
=COUNTIFS(Cases!B2:B552,"1",Cases!G2:G552,"c*",Cases!X2:X552,"No",Cases!AB2:AB552,">0")
Insert New Column After Every 2 Columns
Nov 14, 2007I have many excel sheets with many columns. I want to insert new columns but after every 2 columns, starting from column M.
View 9 Replies View RelatedCombining Two Columns To 1 Column
Dec 12, 2007see the picture below to get an idea of what i want to do.
http://aycu15.webshots.com/image/362...0389296_rs.jpg
Hide All Blank Columns With VBA Apart From Column A?
Aug 22, 2013I just want to Hide all the blank columns on the sheet apart from column A.
I already have this code, just dont know how to alter it:
VB:
Sub HideEmptyColumns() Dim c As Long
Dim n As Long
Application.ScreenUpdating = False
[Code].....
Combine 2 Columns With 3 Choices Into 1 Column?
Feb 18, 2014 I have 2 columns "H" and "I" from line 6 to 409. Each cell may start with AR , MA or a number. If cell H6 starts with AR I would like to put that cell into B6. If H6 does not have AR then I would like to check I6 for AR, and put that into B6 if it's found. If I don't find AR in either I would check them both for MA, and write the cell that finds MA into B6. If the AR or MA are not found then I would want it left blank. I did try
IF(FIND("AR",$H7,1),$H7,IF(FIND("AR",$I7,1),$I7,IF(FIND("MA",$H7,1),$H7,IF(FIND("MA",$I7,1),$I7," ")))) in B7.
Incremental Count Across 2 Columns While Considering 3rd Column
Apr 29, 2014I have a list that tracking teams, specifically, the game number of the season. I also would like to start the count over every month. I have 3 columns to consider in the formula - 1) the month, 2) the home team, and 3) the visiting team. What I hope to accomplish is something like I have listed below. The # columns are blank in the real file - this is just a small example to illustrate what I'm after. Is something like this even possible? Attached is an excel file with this same data.
example.xlsx‎
Adding Duplicate Columns Into New Column?
Jan 6, 2014I have 5 coloums in which the last three have numeric values. The first two coloums have name and country code. Now, The first two coloums have duplicate values but the rest of the corresponding columns have different numeriv values. What I want now is to add the numeric values of the coloumns of the duplicate data and want to display in the first row. For ex there are A = name , B= Country , C D and E contains different numeric values. A and B have dupilcate data but different C, D and E values. Now I want to add up the numeric values of the dupilcate data and get it displayed in a new coloum in the first row of the duplicate data set.
View 1 Replies View RelatedMerge Two Columns To One Filled Column?
Jul 23, 2014I have two columns that are the same field, both Middle Name. The first column does not have every single row filled and the second column has every row the first column does not have and vice versa. I want to merge them to one filled column.
View 2 Replies View RelatedAverage Column Based On Another Columns Value?
Jul 29, 2014I would like to average a column based upon another column value. Namely, if one column is a duplicate, I would like to take the column to its right value and average all the duplicates. For example
comp 1409 99.7
comp 1409 99.5
comp 1409 100
comp 1308 65.7
comp 1509 99.5
I would like that to become
comp 1409 99.73
comp 1308 65.7
comp 1509 99.5
Combine Two Dynamic Columns Into One Column
Nov 13, 2008i need to take all cells in column A with values and all cells in column B with values and combine them into column C so i can sort and subtotal. Columns A and B may have 2 values or 2000 values.
View 10 Replies View RelatedUnhiding Columns (column A That You Can't Click On!)
Jan 29, 2009I have columns A to N hidden and need to reveal them. I know you can manually drag each one to reveal it. But I thought there was a way through highlighting/menu options to reveal them all instantly.
View 3 Replies View RelatedMerging 2 Columns Into 1 Alternating Every Other Column
Aug 12, 2010I'm looking for a way to put data into 1 column from 2 different columns, alternating every other row.
The data looks like this:
A B C
1 2
3 4
5 6
And I want C to look like this:
C
1
2
3
4
5
6
I don't necessarily need to keep the data in columns A and B, as long as C follows this format.
Excellent, just what I was looking for. I couldn't get the UDF working right, I'll try messing around with it, but the Index solution works great!
Copy Data From Different Columns Into One Column
Jan 18, 2013If I just one number in each each (row 1-100) for example, but in different columns, is there a way I can copy all of these numbers so that they are all in the same column--that is, they would stay in the same row but now they would also be in the same column.
View 2 Replies View RelatedPrint Only Filled Columns After Column J
Oct 29, 2013I created a lab result page for long term patients. thus, they may have 1 to 1000 lab results. so i need to create an infinite print range, but just printing the filled ones.
Right after column J, print 2nd page if filled, if not, dont. And printing A1:J6 to every page is a good solution to not to lose data in long term.
[URL]