Hi, i am new here. I need help for this, so I have a long list of data and I need to convert/transform in into comprehensible range or rows. Excel will start a new row after each blank in the column.
like this:
data:
Ref#XXX
Acct#XXX
Desc
Amnt
Acct#XXX
Desc
Amnt
-blank-
Ref#XXX
Acct#XXX
Desc
Amnt
Acct#XXX
Desc
Amnt
Acct#XXX
Desc
Amnt
-blank-
Ref#XXX
Acct#XXX
Desc
Amnt
Acct#XXX
Desc
Amnt
to this output,
Ref#XXX Acct#XXX Desc Amt Acct#XXX Desc Amt
Ref#XXX Acct#XXX Desc Amt Acct#XXX Desc Amt Acct#XXX Desc Amt
Ref#XXX Acct#XXX Desc Amt Acct#XXX Desc Amt
Thanks for any help.
like this:
data:
Ref#XXX
Acct#XXX
Desc
Amnt
Acct#XXX
Desc
Amnt
-blank-
Ref#XXX
Acct#XXX
Desc
Amnt
Acct#XXX
Desc
Amnt
Acct#XXX
Desc
Amnt
-blank-
Ref#XXX
Acct#XXX
Desc
Amnt
Acct#XXX
Desc
Amnt
to this output,
Ref#XXX Acct#XXX Desc Amt Acct#XXX Desc Amt
Ref#XXX Acct#XXX Desc Amt Acct#XXX Desc Amt Acct#XXX Desc Amt
Ref#XXX Acct#XXX Desc Amt Acct#XXX Desc Amt
Thanks for any help.