Remember Me?

#1
April 11th 19, 03:01 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Apr 2009 Posts: 55
Question; Combine datafields from different rows into one row and onecolumn if the data in column A is identical

Hello,

Sometimes a nice question come up to solve

Col.A Col.B Col.C

X123 aaa hhh
X123 bbb iii
X123 ccc jjj
A456 ddd kkk
B678 eee lll
B678 fff mmm
C890 ggg nnn

From row 1 till last; for all the records where in Col.A the data is the same, then combine the data in Col.B and C from those records, into the first row in Col.D.
The combined data into Col.D should be Col.B & ; & Col.C then AltEnter then Col.B & Col.C form the next row etc..
If there are no double rows (datafield in Col.A) then combine for that row only the data in Col.B and C to Col.D

Above result then in

Col.A Col.B Col.C Col.D

X123 aaa hhh aaa; hhh
bbb; iii
ccc; jjj
X123 bbb iii
X123 ccc jjj
A456 ddd kkk ddd; kkk
B678 eee lll eee; lll
fff; mmm
B678 fff mmm
C890 ggg nnn ggg; nnn

It should be (very)great if someone can help me out.

regards, Johan

#2
April 11th 19, 04:06 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,696
Question; Combine datafields from different rows into one row and one column if the data in column A is identical

#3
April 11th 19, 07:21 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Apr 2009 Posts: 55
Question; Combine datafields from different rows into one row andone column if the data in column A is identical

It looks good and works almost as asked. Thanks so far !!!

I think it went a bit wrong do to my explanation and the way this group shows it in the text.

Combining the fields are good, but it was not mean to combine in new inserted rows, but in the first one and then in column D. The Alt-Enter I wrote was mean as the actioncode "CHR(10)" (=new row in cell)

Col.A Col.B Col.C Col.D

X123 aaa hhh aaa; hhh CHR(10) bbb; iii CHR(10) ccc; jjj
X123 bbb iii
X123 ccc jjj
A456 ddd kkk ddd; kkk
B678 eee lll eee; lll CHR(10) fff; mmm
B678 fff mmm
C890 ggg nnn ggg; nnn

In your macro also the records that are combined in a first row where combined in colum D. This was not required, but you can leave this if it is a problem to leave them as it is now in the code.

regards, Johan
#4
April 11th 19, 07:34 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,696
Question; Combine datafields from different rows into one row and one column if the data in column A is identical

#5
April 11th 19, 07:53 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Apr 2009 Posts: 55
Question; Combine datafields from different rows into one row andone column if the data in column A is identical

A-M-A-Z-I-N-G !!!!

Very Thanks a lot. Works very good

regards, Johan

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post [email protected] Excel Programming 2 October 12th 16 07:48 PM johan Excel Discussion (Misc queries) 2 October 19th 09 07:58 PM holmansworld Excel Discussion (Misc queries) 0 February 14th 09 01:41 AM jonnybrovo815 Excel Programming 0 June 5th 07 10:43 PM Tom Excel Discussion (Misc queries) 6 May 3rd 06 09:27 AM

All times are GMT +1. The time now is 07:59 AM.