[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 136
  • Last Modified:

Appending Strings form column

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
flynny
Asked:
flynny
  • 2
2 Solutions
 
regmigrantCommented:
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
 
Rob HensonIT & Database AssistantCommented:
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
 
regmigrantCommented:
nice
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now