i have created an excel table with imported data from a SQL server.
the data being imported in a single column is the users Domain\UID.
Columns B, C, D, etc are used to MANUALLY enter application user ID's (mainframe, etc).
today a new hire was added to the SQL table and was successfully inserted into column A in my excel spreadsheet...
the problem is that all the rows with application ID's did not shift down to accommodate the inserted new user record.
now everything below the new hire is off by 1 row.
how can i import updates with inserted new users AND insert blank cells on the same row as the new domain\uid?
BEFORE
Adam userid1 userid2 userid3
Beth userid4 userid5 userid6
David userid7 userid8 userid9
Eddie userid10 userid11 userid12
AFTER
Adam userid1 userid2 userid3
Beth userid4 userid5 userid6
Cathy userid7 userid8 userid9
David userid10 userid11 userid12
Eddie
SHOULD BE
Adam userid1 userid2 userid3
Beth userid4 userid5 userid6
Cathy
David userid7 userid8 userid9
Eddie userid10 userid11 userid12
if this has anything to do with the SQL, the command am using is:
Select AD_ID From "DATABASENAME" order by AD_ID
the data being imported in a single column is the users Domain\UID.
Columns B, C, D, etc are used to MANUALLY enter application user ID's (mainframe, etc).
today a new hire was added to the SQL table and was successfully inserted into column A in my excel spreadsheet...
the problem is that all the rows with application ID's did not shift down to accommodate the inserted new user record.
now everything below the new hire is off by 1 row.
how can i import updates with inserted new users AND insert blank cells on the same row as the new domain\uid?
BEFORE
Adam userid1 userid2 userid3
Beth userid4 userid5 userid6
David userid7 userid8 userid9
Eddie userid10 userid11 userid12
AFTER
Adam userid1 userid2 userid3
Beth userid4 userid5 userid6
Cathy userid7 userid8 userid9
David userid10 userid11 userid12
Eddie
SHOULD BE
Adam userid1 userid2 userid3
Beth userid4 userid5 userid6
Cathy
David userid7 userid8 userid9
Eddie userid10 userid11 userid12
if this has anything to do with the SQL, the command am using is:
Select AD_ID From "DATABASENAME" order by AD_ID