creating a field that contains the content of the other fields

[Sifiso]

Dear all

I am not sure if what I want is doable.

I want to combine the content of multiple data fields and create one field that will contain all.

for example: 

ChangeID	Title	Amount	Unique ID	Description	Month	Portfolio	BA
SE10233	rework	R20 000	NCR004	The parts are 5 mm oversize	003	Piping	extraction

Required results.

ChangeID	Title	Amount	Unique ID	Description	Month	Portfolio	BA	New Data Field
SE10233	rework	R20 000	NCR004	The outside diameter of the parts is 5 mm oversize	003	Piping	extraction	ChangeID: SE10233 Title: Rework Amount: R20 000 Unique ID: NCR004 Description: The outside diameter of the parts is 5 mm oversize.

[apathetichell]

follow these instructions:

1) recordid.

2) transpose (all fields - except record id - which you use as a key field/column)

3) formula - create a new field - let's call it -NewField

write this formula

[Name]+": "+[Value]

4) summarize tool - group by recordid - concatenate NewField - set \n as your delimiter.

5) Joint this back to step your step 1 data. Join on RecordID.

[Robin_McIntosh]

Here's the example to work from following @apathetichell instructions.

[HomesickSurfer]

Hi @Sifiso 

Assuming that you are combining the fields as a quick summary of the item record, and perhaps intended for some form of reporting, here's my approach with less tools also providing you with added benefit of separate text positioning and formatting, eg: bolding ChangeID:, Title:, etc.