Combining multiple rows into one

[indeegirl]

Hi everyone! I am in need of a macro to combine rows. I have found a few threads similar, and I have tried to adjust the programming to my needs, but I can't figure it out! Basically I have a statement job I will be printing for a customer, that when I agreed to do it, would have one record per sheet. Now it turns out there will be multiple records. So in order for my variable data software (XMPie) to work, I need all of the data on one row. Is this possible? I have attached a file named SAMPLE ROW MERGE. That includes 5 names that need to be on the same row. The data is the same, but the customer must have all rows in the statement. I can't post HTML because the file has 27 columns, so I pasted a sample below. I home someone can help me out with this, I will be VERY GRATEFUL!!! OH and by the way, the trigger should be the ACCT_ID. THANKS!!! (I'm so sorry it looks a mess)

INVNUM	INV_DATE	DUE_DATE	SUB_NAME	SUB_ADDR1	SUB_ADDR2	SUB_CITY	SUB_ST	SUB_ZIP	ACCT_ID	CONTACT	PLAN_ID	CHECK_DATE	CHECK_NUM	CHECK_AMT	TRANS_TYPE	CHARGE_DESC	PREM_AMT	PRE_BAL	BAL_FWD	TOT_PREM	AMT_DUE	PDUE30	PDUE60	PDUE90	PDUE91	MESSAGE	CREDIT_AMT	DEBIT_AMT
17904421	1/8/2011 3:12	3/10/2011	ADRIAN A SAMPLE	123 ADAMS AVE	PO BOX 123	WALLA WALLA	WA	98948	12345678	ADRIAN A SAMPLE	8				IN			104.74	0	0	104.74	0	0	0	0	MESSAGE GOES HERE	0	0
17904419	1/8/2011 3:12	3/10/2011	ADRIAN A SAMPLE	124 ADAMS AVE	PO BOX 124	WALLA WALLA	WA	98948	12345678	ADRIAN A SAMPLE	8	8/6/2010	E99011A	502.9	PY	Payment Received - Thank You		607.64	0	0	104.74	0	0	0	0	MESSAGE GOES HERE	0	0
17904426	1/8/2011 3:12	3/10/2011	ADRIAN A SAMPLE	125 ADAMS AVE	PO BOX 125	WALLA WALLA	WA	98948	12345678	ADRIAN A SAMPLE	8				IN		104.74	104.74	104.74	104.74	209.48	0	0	0	0	MESSAGE GOES HERE	0	0
17904423	1/8/2011 3:12	3/10/2011	ADRIAN A SAMPLE	126 ADAMS AVE	PO BOX 126	WALLA WALLA	WA	98948	12345678	ADRIAN A SAMPLE	8				IN			104.74	0	0	104.74	0	0	0	0	MESSAGE GOES HERE	0	0
17904424	1/8/2011 3:12	3/10/2011	ADRIAN A SAMPLE	127 ADAMS AVE	PO BOX 127	WALLA WALLA	WA	98948	12345678	ADRIAN A SAMPLE	8				IN			104.74	0	0	104.74	0	0	0	0	MESSAGE GOES HERE	0	0

 

[GlennUK]

Can you explain the logic that you want to use. The data is not all the same ... how will you combine all the INVNUMs, for a start?

Maybe using SUBTOTALs would be a good starting point ... you could sum items at change of ACCT_ID, and have a macro copy certain other items from the cell above on the TOTAL rows, collapse the outline and copy and paste, as a guess. It's worth exploring in my opinion.

 

[indeegirl]

Thanks!
I have been so busy with this project. They have decided to go a different route today. So all this extra work for nothing!

Thanks again!