AnsweredAssumed Answered

Consolidating Data for Export

Question asked by FrankNovembre on May 27, 2011
Latest reply on May 28, 2011 by LaRetta_1


Consolidating Data for Export


I would like to consolidate some sales data for import as a formatted text field.

The data is quite large and is over 120,000 lines. Attached is a sample from a spreadsheet.

Is it possible to consolidate the attached data into 2 fields. The first field contains the client code, and the second contains consolidated data for each client code including headers, in a format that essentially is a text field but looks like a spreadsheet with headers.

Some client codes will have only one line of data to consolidate, and others may have up to 10,000.