From 1 Column To 3 Columns
Feb 2, 2013
I 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..
View 1 Replies
ADVERTISEMENT
Jan 31, 2013
I 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
View 2 Replies
View Related
Jun 30, 2014
I 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
View 8 Replies
View Related
Jul 13, 2014
When 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 Related
Mar 7, 2014
I wondering how to put together for example column A and column B to one column? is it possible?
View 4 Replies
View Related
Feb 5, 2009
I 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 Related
Aug 12, 2014
I 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
View 1 Replies
View Related
Mar 11, 2014
Column 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
View 5 Replies
View Related
Aug 13, 2014
I'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?
View 12 Replies
View Related
Dec 22, 2007
I 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.
View 14 Replies
View Related
Sep 10, 2009
I 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 Related
Sep 30, 2009
I 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.
View 2 Replies
View Related
Nov 25, 2009
I 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.
View 5 Replies
View Related
May 11, 2009
I 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
View 3 Replies
View Related
Apr 23, 2012
I 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 Related
May 23, 2013
I 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]....
View 1 Replies
View Related
Jun 27, 2013
I 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")
View 3 Replies
View Related
Nov 14, 2007
I 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 Related
Dec 12, 2007
see the picture below to get an idea of what i want to do.
http://aycu15.webshots.com/image/362...0389296_rs.jpg
View 9 Replies
View Related
Aug 22, 2013
I 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].....
View 2 Replies
View Related
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.
View 6 Replies
View Related
Apr 29, 2014
I 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‎
View 2 Replies
View Related
Jan 6, 2014
I 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 Related
Jul 23, 2014
I 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 Related
Jul 29, 2014
I 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
View 6 Replies
View Related
Nov 13, 2008
i 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 Related
Jan 29, 2009
I 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 Related
Aug 12, 2010
I'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!
View 5 Replies
View Related
Jan 18, 2013
If 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 Related
Oct 29, 2013
I 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]
View 3 Replies
View Related
