Can a "what if" statement be used to insert cells?

A

A.R. Hunt

I have side by side reports of thousands of lines of similar data. There may
be multiple lines pertaining to the same id#--one side may have 3
transactions for an id#, where the other may have 4, causing me to need to
bump the cells down on one side to keep matching id#s lined up side by side.
Can I use a helper column with a "what if" statement to insert cells? If so,
could you give me an example? Thanks in advance.
 
A

A.R. Hunt

Columns:
A:Name
B:Term
C:Amount
D:Hours
E:SSN

I:SSN
J:Last Name
K:First Name
L:Term abbreviation
M:Amount
N:Hours

Columns F, G, H return the differences in SSN, amounts, and hours. They are
conditionally formatted so that if the they are not zero, they are red. If
the SSN is not zero, I must insert cells so that matching SSNs are side by
side. For any SSNs that aren't on both sides, I must research why not. Also,
if hours and amounts are different, I must research what caused the
difference.
 
Top