Turning Columns To Rows?
May 14, 2012
Current Tabel:
Sheet1
ABCDEFGHIJKLMNO1EVENT NAME DATEGROUP / LOGOEVENT LOCATION DELIVERY DATEITEMCountMUGSBLK T'SPADSGREY T'S DRIVEBLK PENSCOINSBLK POLOS35Inter.05/01/12ABCShip to ABC04/25/12 60 45 32
This is what I want to do with it:
Sheet1
ABCDEFG1EVENT NAME DATEGROUP / LOGOEVENT LOCATION DELIVERY DATEITEMCount35Inter.05/01/12ABCShip to ABC04/25/12MUGS6036Inter.05/01/12ABCShip to ABC04/25/12BLK T'S 37Inter.05/01/12ABCShip to ABC04/25/12PADS4538Inter.05/01/12ABCShip to ABC04/25/12 DRIVE3239Inter.05/01/12ABCShip to ABC04/25/12GREY T'S 40Inter.05/01/12ABCShip to ABC04/25/12BLK PENS 41Inter.05/01/12ABCShip to ABC04/25/12COINS 42Inter.05/01/12ABCShip to ABC04/25/12BLK POLOS
View 9 Replies
ADVERTISEMENT
Aug 10, 2008
I have individual data files (one for each participant). Each file has 64 rows (one for each trial in an experiment) and 18 columns (one for each variable). I would like to create a master data file in which each participant is represented in a single row. I will then have 1152 columns (18 columns for the variables, repeating 64 times so that each trial is represented).
In other words, my individual data files look something like this:
Participant 1 (title of data file)
Trial/var1/var2/var3
1 55 43 65
2 54 43 56
3 33 23 56
and I want to compile all the data into a single file that looks like this:
Participant/Trial1_var1/Trial1_var2/Trial1_var3/Trial2_var1/Trial2_var2/ ...
1 55 43 65 54 43
2 . . .
I know how to record macros and use IF, THEN, AND, & SUMIF statements creatively, but that's about it. I was hoping to record a macro that I could use on each individual data file to turn it into a single row, and then paste each row into the master file.
View 9 Replies
View Related
Feb 23, 2010
The format of the text in which I need to extract numbers is as follows:
23411268 - 23411270
Need to extract the following:
23411268
23411269
23411270
These numbers have to be listed in three seperate rows.
View 14 Replies
View Related
Jul 28, 2013
i need to mark some row (which has some content written in), mark other row(with data too) and switch/transpose them mutual. when i was trying transpose method, which is using for switching rowns and columns, it wrote me error, that data are overlapping. it means it cant work on same things (rows > rows, columns > columns).
View 14 Replies
View Related
Jul 8, 2008
I have this annoying problem with my excel 2003. And i have no clue at all how to solve this.
Each time i write 2.5 it turns into 02.may. Does any one know how i can fix this?
View 14 Replies
View Related
Oct 22, 2013
I fill out this form everyday and sometimes need to type "S" and every time it fills in "Sampling Rate #1" because that's what it says in the same column higher up. Is it possible to turn this off somehow?
View 3 Replies
View Related
Apr 13, 2008
I want to turn on (tick) a check box from within a macro.
View 9 Replies
View Related
Jun 13, 2006
I have a sales and prospects spreadsheet. It has information in columns A to O. The last 3 columns M, N and O, require a 'Y' for Yes or 'N' for No entry. If entering N, the background colour of the cell turns grey using conditional formatting, and if entering Y the background colour of the cell turns Gold using conditional formatting. Column O is headed 'Sold', so that column is onviously the final Y. Upon entering Y in column O, ie the sale is made, I's like it that the whole row, so all cells of that row in columns A to and including O turn gold to easily visually differentiate done deals from prospects.
Also what would be cool is if when a deal is done, it not only turns the whole row gold, but moves the row to the top of the sheet, so by dividing done deals from prospects, that is utopia at this stage though, more important is turning the row gold upon a Y entry in column O.
View 9 Replies
View Related
Dec 12, 2007
I recently installed Office 2002 onto a new computer and found that whenever I drag-and-drop any amount of data from one cell to another, a loud obnoxious noise plays when I release the drag-and-drop data.
I was using the same version of Office on my old computer and did not have this problem.
I'm guessing it's a clipboard issue, since when I open the Excel clipboard (where I currently have all options as unchecked) and copy something so it is captured there, the same noise plays.
I already have turned off Windows sounds via the Control Panel and have no clue how to turn off this sound.
View 12 Replies
View Related
Feb 13, 2014
I'm going through financial statements and I would like to be able to run full blown analysis on them. Most public financial reports are written so that a lot of zero's do not take up the useful space. As such (and there is a ton of this solution out there I've found), many people want to take $1,500,000,000 and turn it into 1.5M
I however, do not. I want to convert it backwards. So when something says 5.19 I would like to format it in such a way that it will read (and I can run calculations against it) as 5,190,000,000 (there are no alpha characters, there are instances where there will be negative numbers). Then I could copy this to the 17 different financial statements I've already got rock'n rolling in Excel right now.
View 4 Replies
View Related
Mar 18, 2014
I have the Macro
[Code]....
That starts a timer macro (Recalc) in my excel sheet when the workbook is opened, my issue is that when the work book closes it continues to run.
Will the following macro fix this problem, or is there some command like Workbook_Open() but for closing?
[Code] ....
View 1 Replies
View Related
Sep 23, 2009
I have a workbook that has many Pictures created with the Camera command. I have found that VBA macros in any workbook open at the same time as the one with Pictures run very slowly. Is there a way of temporarily turning off the Picture Refresh within the VBA in the same way as you can turn off automatic formula updating.
Keith
View 7 Replies
View Related
Oct 18, 2011
I have 2 lines with pairs and 3rd with corresponding values, nee to construct a matrix out of it with formulas
Example
Need to turn
AAABBDBCDCDC0.30.20.130.550.840.43
into
ABCDA11-0.31-0.21-0.13B0.311-0.551-0.84C0.20.5510.43D0.130.841-0.431
So the one that stands above in the initial file goes to the top line in the matrix. 2 line -> column in matrix. In case there is no match need to seek reverse in 1,2 and reflect as 1-VALUE in the matrix
View 3 Replies
View Related
Apr 1, 2014
How to stop my 100% from changing to 1000% after it pastes?
Here's the pc of code that is performing the copy/paste from one sheet to another sheet within the same workbook..
Code:
With Sheets("BOM Worksheet").Range("C" & nr)
.Value = c.Offset(, -16).Value
.Font.FontStyle = "Bold"
.Font.Color = RGB(186, 85, 211)
End With
View 6 Replies
View Related
Aug 28, 2008
I have a column of dates and have been asked to turn a cell next to it green, orange or red but I don't think this can be done?
Otherwise is there a way to turn the background of the cell a different colour, am sure there is?
What I need is if for example the date in the column is 01.08.08 then up until 7 days I want it to turn green, between 8-10 days I want it to go orange and over 10 days it needs to go red. Is this possible?
View 9 Replies
View Related
Dec 17, 2008
I need to turn a list of information into a true spreadsheet, how do I look up the information to fall under the appropriate headers?
Example:
Instead of...
Invoice # 000
Date Of invoice 01/01/08
Name: Smith/Steve
Invoice # 001
Date of invoice 01/01/08
Name: Smith/Sally
I need...
Invoice Date of invoice Name
000 01/01/08 Smith/Steve
001 01/01/08 Smith/Sally
View 9 Replies
View Related
Jan 14, 2009
"Decision Date". It is a numerical date (ex: 1/5/09 indicating January 5th 2009).
I need to turn that date into the week that it falls into within a particular quarter of a year.
1/5/09 would be Week 2 (it is in the second week of January, and 2nd week of the quarter)
2/3/09 would be week 6 (6th week of the quarter).
And then I need the formula to start over once each quarter restarts... for example, April 1st would be week 1 (1st week of the second quarter).
View 9 Replies
View Related
Feb 3, 2010
I have this formula:
=IF('2010'!R10C2="y",'2010'!R10C3,"")
And I want to be able to drag it down and have the cells update, but all it does is keep the same values.
Is there something I need to turn on or off.
View 9 Replies
View Related
May 30, 2006
i would like to know how to turn the word beside into numbers, ie if b=2,e=5,s=60,i=10,d=4,
also can this word be in the one cell or would it have to be entered separately, ie one letter per cell??
View 9 Replies
View Related
Apr 23, 2007
how to turn on the Comment Indicator through VBA? The code equivalent of setting Tools / Options / View and then selecting the Comment Indicator Only option.
View 2 Replies
View Related
May 20, 2014
Is it possible to create a rule that every time I type my name, for my e-mail address to pop up in excel instead?
For example, if I type "purple1686", I want "12purpleexample@domain.com" to show up as a hyperlink to my default e-mail program.
I am also curious if I was to write "my website" is it possible to make it a hyperlink to "www.purple1686example.com"?
Those two first may be easy to answer, so here is the challenging part for me:
Can I make that happen as a rule on every spreadsheet I open?
I don't know if I should make a template, or use a formula? The ideal scenario would be if there was a way to do it through conditional formatting.
I have used conditional formatting to change the color of a word every single time I open a new template and paste the words into it, or even by typing them out.
View 1 Replies
View Related
Jul 26, 2014
Is it possible to turn monthly data into daily? Repeating the same data for four sets of five working days to turn a CPI monthly inflation index into daily data, to turn example 1 into example 2.
Example 1.
DATEVALUE
2008-01-01 212.174
2008-02-01 212.687
2008-03-01 213.448
2008-04-01 213.942
2008-05-01 215.208
Example 2:
2008-01-01 212.174
2008-01-02 212.174
2008-01-03 212.174
2008-01-04 212.174
View 3 Replies
View Related
Dec 11, 2008
I populated an XL sheet from another one using a formula. However, in order to use my new sheet I need all the cells to be numbers and not formulas. Is there a way to turn all the formulas into numbers, leaving behind just the numerical value ? Basically like pasting only values, only without having have to paste them somewhere else.
View 2 Replies
View Related
Jun 9, 2009
what i want to do is say:
If A1="" then color B1 and C1 black, basically turning those cells off
View 2 Replies
View Related
Aug 4, 2009
I am looking to do find the latest date in a list of dates but have several problems:
1) The dates are all in one column on worksheet 1, but are sourced from other worksheets. So even though it looks like '8/7/09', the value of the cell is 'Worksheet2!B4'. This is making the MAX function not work
2) How to deal with the blank cells in the MAX function?
View 12 Replies
View Related
Feb 5, 2013
I am exporting data in from a different program (Results Plus), into a Word 2010 mail merged document with a header file attached. The header file is an Excel table of my merged fields. I have gone through all the steps to make sure it's not that software. Now I still cannot figure out why all of my months are turning into "00" in a Word mail merge. I have tried @ "MM/dd/yyyy" and it end ups flipping the month and day around.
For example: it should be January 8, 2013. It shows up originally in my document as "00 8, 2013". When I add the [switch] @ "MM/dd/yyyy" it shows up as, "08/01/2013". When I tested it out and put "MMMM/dd/yyyy" it shows up as August 1, 2013 instead of what it should be, January 8, 2013.
I have checked my default language (English US).
How do I stop this?
View 8 Replies
View Related
Jul 8, 2013
I am trying to enter the last name "Teh" in a cell. How do I turn off auto spell correction that turns "Teh" into "The"?
View 3 Replies
View Related
Jan 10, 2012
Is it possible to turn a range of data into a more detailed table.
for instance -
the input data would be something like
1 - 3 @ 50%
4 - 6 @20%
8-10 @70%
the output i'm looking for would be a table like below
1 - 50%
2 - 50%
3 - 50%
4 - 20%
5 - 20%
6 - 20%
7 - 0
8 - 70%
9 - 70%
10 - 70%
View 3 Replies
View Related
Feb 6, 2012
How can I do the following:
I need a toggle switch that switches between protecting and unprotecting the worksheet.
It should display the text 'Entry Mode' when the sheet is protected and 'Filter Mode' when the sheet is unprotected.
View 3 Replies
View Related
Mar 14, 2012
Background info: I have developed a Hired Equipment Time Sheet with numerous formulas to auto populate and calculate various cells to minimize user impute requirements.
Can cell formulas be toggled on and off to allow manual impute of data rather than the formula automatically populating information in the cell if the need arises? If so, can this be done via a drop down pick? Also can or will the formula still be protected?
View 2 Replies
View Related
