?
Solved

Appending Strings form column

Posted on 2014-01-14
3
Medium Priority
?
127 Views
Last Modified: 2014-02-07
Hi all,

I have a summary sheet in an excel.

I want to make a summary of a purchase order column which i text

so for example if I had the following column

Purchase Order
C-193
C-193
C-193
C-190

The summary text would be C-193,C190

is this possible without using macros?
0
Comment
Question by:flynny
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 19

Assisted Solution

by:regmigrant
regmigrant earned 1000 total points
ID: 39778942
Use Data, Advanced filter, unique rows to create a list of the individual items in (for example) column D

then in column E2  put
=D2

Then in E3 put

=D3 & "," & D2 & ","

If you copy this down column b you will get all of the rows added together in the final row - it will have an extra comma on the end. Copy this cell and 'paste, special, values' to a new field and you have a text version from which you can delete the extra comma
0
 
LVL 33

Accepted Solution

by:
Rob Henson earned 1000 total points
ID: 39778970
You can also use a Pivot Table to create a list of PO references.

Another formula option without creating a unique list would be:

Assuming PO reference in column D like above and assuming references are sorted in order.

Against the first reference put, assumed entry in E2:

=D2

Start this formula in row of second entry, even if same PO as first entry:

=IF(D3=D2,E2,E2&","&D3)

Copy down list of data. The last entry will then be the complete list.

Thanks
Rob H
0
 
LVL 19

Expert Comment

by:regmigrant
ID: 39779061
nice
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question