Automate Repetitive Excel Task

July 23, 2011 at 20:20:08
Specs: Windows XP
On one worksheet I have 4 rows of exactly the same data with one column only containing a new data. E.g.:
A100 A 1
A100 A 2
A100 A 3
A100 A 4
I want to keep only one row of the data and have column C data listed with semicolons
A100 A 1;2;3;4

Do you know if there is a way to automate this task?


See More: Automate Repetitive Excel Task

Report •


#1
July 24, 2011 at 01:16:54
You did not include Row or Column labels so I am going to assume that your data is in A1:C4.

If that is the case, then try this:

=A1 & " " & B1 & " " & C1 & ";" & C2 & ";" & C3 & ";" & C4

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question