convert row to column
I have information in a row on a spreadsheet. Is there a way to copy/cut and
paste that information into a column instead?
Have you tried the Transpose yet? You copy the row, select the column you want to put the data in, paste special and check the transpose box
Highlight and Copy the Row;
then go to the column cell you wish the data to goto and click/select it,
do an Edit Paste-Special (check) Transpose<<Consider if you want to further
paste the de-formularized Value or not, also before ending>>
"Ivor Williams" <email@example.com> w...how to revert columns to rows
example: i need to revert table
A 1 2 3 4 5 6
to this format
A B C
Copy the cells. Go menu edit > paste special and choose "transpose".
HTH. Best wishes Harald
"agenda9533" <firstname.lastname@example.org> skrev i melding
> example: i need to revert table
> A 1 2 3 4 5 6
> to this format
> A B C
> Thank you.
see topic below
"agend...Changed Titled bar and now sort doesn't default to "Header Row"
I feel like an idiot. I deleted the first row in a data field that I used to
be able to sort by. After inserting a new row and re-titling each column,
when I go to sort now the default comes up "No Header Row" and I have to
switch it back to "Header Row". Is there something I can do to get it to
default back to "Header Row" like it was before I messed it up?
Excel likes to see something different that distinguishes the header row. One
easy fix is to bold that header row.
> I feel like an idiot. I deleted the first row in a data f...PivotTable Column Field Values
The column field list of my PivotTable (when one clicks on the
drop-down arrow) is populated with a list of items which no longer
exist in the data table from the data is drawn.
Is it possible to reset these values so that only valid data can be
Please let me know if I have not explained the problem adequqtely.
There are instructions here for clearing old items from a PivotTable
Michael Rekas wrote:
> The column field list of my PivotTable (when one clicks on the
> drop-down arrow) ...test for events as they occur on a different form
Is there any way to have VBA code in one form test for events that are
occurring on another? Something like:
The idea is to have a form that's always open run a test generically on
whatever other form happens to have the focus at that time, and to do it
without having to write any supporting code on the other form.
Here's the quick rundown on why I ask:
I already use a hidden form that tracks how long it's been since the focus
has been changed to a new active control and closes the db if it's been idle
Please forgive my ignorance but I just don't know anything about Excel. I
have an expense report that I have to file monthly that has to show daily
mileage for both company and personal mileage. I want to automate the
functions as much as I can as an aid to ensuring accuracy. Each day has its
own line and data with totals for the data at the bottom. Here are my
1) How do I get the current date to automatically load into the appropriate
cell? In other words, when I open this file daily how do I get the current
date to appear in the cell but still retain the option o...Compare two columns with different codes
I have two columns with codes.
The first column include the main coding (ie: ab1, ab101, ab10101,...)
The second column include the same codes, but the first leter is always C.
So the coding is (ie: cab1, cab101, cab10101,...)
I have notice that some of the codes in the second column are missing.
There is any way that i can make a check regarding the second column based
the first one. I tried to use the vlookup but the problem is that the first
letter is c and basically the two codes looks different.
Can anyone direct me of how i can make the comparison between the two col...How to freeze NOW()
I am using the NOW() to avoid typing in the date/time of some data i am
the problem is that all the cells with now get recalculated every time i
enter new data in the spreadsheet.
How do I "freeze" the older data so that NOW() does not get recalculated
in those cells or is there a way to transform the output of now into
some text so that it does not get recalculated?.
Rather than =NOW(), type CTRL+; (semi-colon) followed by space and then
to get date and time as if you had typed them
htt...Extracting data from two columns
I have data in B1-B1000+ and C1-C1000+ that I need in column A. The problem
is that column B & C are filled with data. Column A has specific cells that
the data needs to go into. In the example below B1 and C1 represent the data
from columns B & C that need to be in A2 and A3. And b2 and c2 need to be in
A7 and A8. This pattern continues for 1000+ rows.
Thank you in advance!
A B C
1 $$un $$tdp $$dac
2 B1 $$tdp $$dac
3 C1 $$tdp $$dac
4 pause $$tdp $$dac
5 $$tdp $$dac
6 $$un $$tdp $$dac...right justify number column within listbox
Is there a way to right justify a column within a listbox containing number
thanks in advance, George.
"George" <George@discussions.microsoft.com> wrote in message
> Hello everybody,
> Is there a way to right justify a column within a listbox containing
> type data?
> thanks in advance, George.
There's no built-in way, but I have a (rather kludgey) method which
calculates the number of "left padding" spaces to insert. Let me know if
you...Last Day of a Week based on NOW()
Good evening all,
Just a quick question. How would I work out what all the days in a wee
are, based upon the current date.
So, have 7 cells, which would work out what their date is, based o
today. Example. Today is Thursday, 24th June.
Tuesday - 22/06/2004
Wednesday - 23/06/2004
Thursday - 24/06/2004
Friday - 25/06/2004
Saturday - 26/06/2004
Sunday - 27/06/2004
Is this actually possible? With vague thinking, I beleive it might be
but I'm not exactly sure how I'd go about working it into a formula
Maybe a helper column that would place the the current date into th...Now
I'm using excel and it is asking me to use NOW formula
"Jill graeve" <email@example.com> wrote in message
> I'm using excel and it is asking me to use NOW formula
> "Jill graeve" wrote
> > I'm using excel and it is asking me to use NOW formula
"Bob Phillips" wrote
> Where? When?
I'd guess... in school?
"Bob Phillips" <firstname.lastname@example.org> skrev i melding
I got a cell A1 with a now function =now() which gives the current time.
Cell A2 has a time that is entered, and cell A3 has an if function that
compared if(A1>A2,"","Do Something"). However, the if statement is true all
the time even if the time is cell A2 is a later time than A1. I changed the
format in cell A1 from a time format to a general and it turn out to be a
big number. Otherwise, I changed the time format in cell A2 into general
and it is a very small decimal number. How do I get around this, may with a
mod function or something?
NOW gives both ...can't send and receive, test message settings reports no errors
New vista laptop, installed our volume licence Office 2003, copied
mail settings from older XP machine, test mail settings reports no
errors, test messages go in and out with no problem, but send and
receive within the program gives error -
!Task 'pop.googlemail.com - Sending' reported error (0x8004010F): 'The
operation failed. An object could not be found.'
!Task 'pop.googlemail.com - Receiving' reported error (0x8004010F):
'The operation failed. An object could not be found.'
Possible cause - when I booted the laptop last week it had a trial for
Office 2007 ...How to copy the url for a list of cell with hyperlinks in another column?
How to copy the url for a list of cell with hyperlinks in another column?
With the hyperlinks in Col A run this to copy the address in Col B
Dim hlnk As Hyperlink
For Each hlnk In Columns("A").Hyperlinks
hlnk.Parent.Offset(0, 1).Value = hlnk.Address
Regards Ron de Bruin
"jaya" <email@example.com> wrote in message news:firstname.lastname@example.org...
> How to copy the url for a list of cell with hyperlinks in another column?
I have installed the CRM server 1.2 on a win2k server. When I try to install
the CRM for outlook app, it says it is already installed. How do I now run
the CRM app?
Sales for Outlook can't be installed on the same machine of CRM. To use CRM
you need to connect to the address http://<servername>.
"John" <email@example.com> wrote in message
> I have installed the CRM server 1.2 on a win2k server. When I try to
> the CRM for outlook app, it says it is already instal...Is there a way I can enter a letter to proceed text a column of ce
I need to enter a source code (letter W) before all the text that I have
listed in a column. Example: All of column C has text... MPV001, MPV002,
MPV003, ETC. I need to put a "W" in front of all the text. i.e. WMPV001,
WMPV002, WMPV003, ETC. Is there a way to do this without manually typing W
in all the cells? The spreadsheet has 1500 rows...
> I need to enter a source code (letter W) before all the text that I
> have listed in a column. Example: All of column C has text...
> MPV001, MPV002, MPV003, ETC. I need to put a "W" in front of...Microsoft... come on now...
Ok, so many of your mac support pages lead to "page not founds".
Great, thanks. On your mactopia support page:
click on "Office 2004 for Mac". Nice huh? Now, open say, Excel. Go to
"Excel" in the top menu bar, click "About Excel". Now, in the
resulting window click on "Support". Now, click on the first link, the
one that says, "http://support.microsoft.com", which by the way isn't
even the mac support page for this product, but no matter, you get a
"page not found" anyway.
It&...add alpha letter to column of numbers
I have a column of part numbers that I want to re-identify with a "W" in
front of the number. There has to be a quick way of doing this but
everything I have tried fails.
One way is to CONCATENATE.........using a helper column, say column B, put
this in B1 and copy down
Then do copy > PasteSpecial > Values on Column B to remove the
formulas........then delete column A if you wish......
It can also be done with VBA code, without using a helper column, if that
method is of interest.......
Vaya con Dios,
"-John W.&...how to sort rows with only two columns?
Using excel I have set up a file that has all my dvd's. This file has four
columns: genre/title/year/minutes. I have no problem adding newly purchased
dvd's to the list and sorting by title. I always add the new ones to the end
of the list.
The problem I have is with my book collection which only has two columns:
genre and title. For some reason, it will not sort by title. The name of this
file is MY BOOK COLLECTION, which is row 1. It is merged and centered with
columns 1 & 2. After I click on SORT the window has MY BOOK COLLECTION in it
and I cannot get it to sort by TITLE...Search a column
I would like to search down a column for a result in another, however
cant work out how to do it.
It isnt as simple as matching up A1 with B1 all the way down, there ma
be something the same as A1 anywhere from B1 to B3000!
I would greatly appreciate some help!
Message posted from http://www.ExcelForum.com
to return the row number
> Hi there.
> I would like to search down a column for a result in another, however
> i cant work out how to do it.
> It isnt as simp...Problem in Dynamic Column Sorting
I changed one of my CRM reports as far as article in
"http://msdn2.microsoft.com/en-us/library/Aa681483.aspx" address, after
deploying this report, clicking to column header caused the report Post-Back
but there isn't any effect of Sorting action in report. Would you please help
me about this problem?
IR-0912 *** ****
Another questions about this problem:
- I think the Value of CRM_SortField parameter can not be any Alias field as
DATEDIFF(minute, CRMAF_Incident.createdonutc, CRMAF_Incident.modif...Free Jewel Box Liner Template in Many Formats - Disc Case Cover
At the following address you can find a free template for making
paper jewel box inserts (liner notes for CD cases):
searchsubmit wrote ...
> At the following address you can find a free template for making
> paper jewel box inserts (liner notes for CD cases):
And that template and several others in PowerPoint (PPT) format
I do all these things in PPT now. Quick, flexible, easy.
If you already use MS Office, no new application to learn.
...Everything works now....
I'm scared to breathe! All my bank, brokerage, and
credit accounts sync and are updating with the right
balances (even that pesky Ameritrade one). No duplicate
accounts....no freaky download issues.
I'm sure next time I log on, Money will have turned my
personal finances into a jigsaw puzzle.
When you were having problems updating, what did you do
to fix it?
>I'm scared to breathe! All my bank, brokerage, and
>credit accounts sync and are updating with the right
>balances (even that pesky Ameritrade one). No duplicate
>ac...Values in multiple columns into one column
I have a spreadsheet with values in multiple columns
where for instance col A is blank colb or c or d won't
be...there will be something in one where the others are
empty. I need to create a column with all the values
together. Tried using the following formula but it
doesn't seem to work... the values are all dates..
=IF(O2=" ",N2,IF(N2=" ",K2,IF(K2=" ",J2,O2)))
Can anybody help!!