4
49niner
I have a list with different companies in column A. My problem is I have to
create a report that should only print the name for each company once and
list the staff matched to the company under the company name.
example: A B C D E
F
ACME Jones Sally
MINOR Brown Jack
FLOSS Kahn Shri
DUNKIN Cow Holy
ACME TT KK
ACME JJ BB
MINOR Notes Keys
Report example:
A B C D E F
ACME
TT KK
JJ BB
Jones Sally
DUNKIN
Cow Holy
FLOSS
Kahn Shri
MINOR
Brown Jack
Notes Keys
If anyone can resolve this for me I would greatly appreicate it!
53214920
create a report that should only print the name for each company once and
list the staff matched to the company under the company name.
example: A B C D E
F
ACME Jones Sally
MINOR Brown Jack
FLOSS Kahn Shri
DUNKIN Cow Holy
ACME TT KK
ACME JJ BB
MINOR Notes Keys
Report example:
A B C D E F
ACME
TT KK
JJ BB
Jones Sally
DUNKIN
Cow Holy
FLOSS
Kahn Shri
MINOR
Brown Jack
Notes Keys
If anyone can resolve this for me I would greatly appreicate it!
53214920