Hi -
I have a report that downloads to excel with information in columns:
account name code tel #
12345 john pe 5551212
12345 joe sl 5551213
12345 jane ca 5551214
6789 bill sl 4441111
6789 brenda ca 4441112
6789 brad pe 4441113
and I need to move everything into rows like this:
account name code tel# name code tel#
12345 jane ca 5551212 joe sl 5551213...
6789 brenda ca 4441112 bill sl 4441111
Is there a way to automate this so that I don't have to cut and paste everything...
I am new at this posting thing, so i hope this comes out right!!!
~s
I have a report that downloads to excel with information in columns:
account name code tel #
12345 john pe 5551212
12345 joe sl 5551213
12345 jane ca 5551214
6789 bill sl 4441111
6789 brenda ca 4441112
6789 brad pe 4441113
and I need to move everything into rows like this:
account name code tel# name code tel#
12345 jane ca 5551212 joe sl 5551213...
6789 brenda ca 4441112 bill sl 4441111
Is there a way to automate this so that I don't have to cut and paste everything...
I am new at this posting thing, so i hope this comes out right!!!
~s