Hi Max,
Again, excellent!

There is a small thing that I need help in this question. Please.
It returns to my designed outputs. Great! However, the data of combined
field (c)appear very close. I would like to make them separately.

Ex: A B
C
Department 1000 then it becomes
Department 1000
Education 200
Education200
Test 5
Test5
I wish they could show like the format below.

Department 1000
Education 200
Test 5

Please help.

Thank you so much!
Chi

"Max" wrote:

.. if data are entered in A1:A300 and B1:B300
(they need go together)

Assume the above is made in Sheet1 as before

In Sheet1,

Put in C1: =TRIM(A1&" "&B1)
Copy down to C300

In Sheet2, change the reference to point to Sheet1's col C instead of col A,
i.e.

Put in A1:
=IF(INDIRECT("'Sheet1'!C"&COLUMNS($A$1:A1)*60-60+ROWS($A$1:A1))=0,"",INDIREC
T("'Sheet1'!C"&COLUMNS($A$1:A1)*60-60+ROWS($A$1:A1)))

Copy A1 across and fill down to E60 as before
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Chi" wrote in message
...
Thanks Max, I got it. It is wonderful!

For another case that if data are entered in A1:A300 and B1:B300 Ex:
A B

Education 2003
Data are entered in A and B columns will stop at row 60 and continue to
fill
in D1 and E1 columns and go on....

Please help .
Thanks
Chi