Hello everybody. I am new here and hoping someone is willing to help. I just want to know if anyone can tell me how it would be possible to combine two separate rows in excel while adding certain pieces of information and keeping others the same.
Here is what I mean. I want to combine the same products into one row. While keeping the product number and per unit price the same while adding the quantity's together and updating the total cost. Also if possible indicate the number of different customers for the customer column.
So that this will look like...
Thanks a lot and any and all help will be greatly appreciated!
Moderator's Comments:
Please use next time code tags for your code and data
i am currently using a unix environment and will be constantly receiving documents in excel format(.xls) my question is
is there any tools that will do auto convertion of data in the excel doc into .txt?
ps.. my job are mainly for batch processing. thus it would be great if no manual work is... (2 Replies)
Folks;
I'm writing a shell script to extract some field out of log file to a text file which i can convert/open in Excel sheet.
I gave names to the fields like (Editor_name, Owner, etc..) to be in the top of the Excel sheet.
When i open the file using Excel sheet i see these filed names fine on... (2 Replies)
Hi,
I am trying to find a way to read an excel work book with multiple worksheets.
And write each worksheet into a new excel file using perl. My environment is Unix.
For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
I have a .csv file, when i open it in excel sheet the content is getting displayed in scientific notation (E+e.) , now inorder to remove tht i have appended ' (single quote) infront of the number. This is working fine. But when i open in excel the ' single quote is appearing before the number. My... (1 Reply)
I have file called abc.txt at /usr/abc..
Content of file is as below.
mZ2|uM/KRCNB30103/1|BADR|NLRDC00C/W | |201105|I|2
oZ2|iM/KRCNB30103/1|BADR|NLRDC00C/W | |201105|I|2
pZ2|qM/KRCNB30103/1|BADR|NLRDC00C/W | |201105|I|2... (3 Replies)
Hello,
I have received very much needed help in the past from this forum and hope that someone can assist me once more. I am in the military and I am tracking classroom specific training for each one of our units per sailor in that unit. I am attaching the spreadsheet for your review. There are... (5 Replies)
I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix
But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed.
What to do...Please... (7 Replies)
All,
I have an excel sheet Excel1.xls that has some entries.
I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls
These may be in different workbooks. They are totally independent made by 2 different users.
I have placed them in a... (1 Reply)
Hi Folks,
Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are
1excel.xslx
2excel.xslx
3excel.xslx
now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
LEARN ABOUT DEBIAN
drs_tool
drslib() drslib()
NAME
drs_tool - Command-line interface to DRSLIB
SYNPOSIS DESCRIPTION USAGE
Usage
Usage: drs_tool [command] [options] [drs-pattern]
command: list list publication-level datasets todo show file operations pending for the next version upgrade make changes to
the selected datasets to upgrade to the next version mapfile make a mapfile of the selected dataset history list all versions of the
selected dataset init initialise CMIP5 product detection data
OPTIONS --help display this help message and exit
--version
output version information and exit
-h, --help show this help message and exit
-R ROOT, --root=ROOT
Root directory of the DRS tree
-I INCOMING, --incoming=INCOMING
Incoming directory for DRS files. Defaults to <root>/output
-a ACTIVITY, --activity=ACTIVITY
Set DRS attribute activity for dataset discovery
-p PRODUCT, --product=PRODUCT
Set DRS attribute product for dataset discovery
-i INSTITUTE, --institute=INSTITUTE
Set DRS attribute institute for dataset discovery
-m MODEL, --model=MODEL
Set DRS attribute model for dataset discovery
-e EXPERIMENT, --experiment=EXPERIMENT
Set DRS attribute experiment for dataset discovery
-f FREQUENCY, --frequency=FREQUENCY
Set DRS attribute frequency for dataset discovery
-r REALM, --realm=REALM
Set DRS attribute realm for dataset discovery
-v VERSION, --version=VERSION
Force version upgrades to this version
-P FILE, --profile=FILE
Profile the script exectuion into FILE
--detect-product
Automatically detect the DRS product of incoming data
REQUIRES FILES
drs_tool uses metaconfig to configure and store configuration information. Its configuration may be found then in a metaconfig.conf file,
in /etc/metaconfig/metaconfig.conf on Debian systems, which may be overriden by $HOME/.metaconfig.conf or ./metaconfig.conf
ENVIRONMENT VARIABLES
The variable METACONF_CONF
VERSION
0.3.0a3
BUGS
To query and report bugs in drs_tool, please use reportbug on Debian systems.
SEE ALSO
http://esgf.org/esgf-drslib-site/index.html
AUTHOR
DRSLIB was written by Stephen Pascoe, STFC.SC.UK. This manual page was written by Alastair McKinstry.
drslib()