Extract some fields from a Row to a column

V

VicV

Hi! Frank

Thanks for your help, Follows a sample of my database, as you'll see
try to get the info in row 2 to column B and row 3 to Column C.

Thanks Again

Column A Column B ColumnC Column D Colum
E

Row 1 GEORGE CLAUDIA Row 2 Row 3 SARASOTA F
34237
Row 2 2750 RINGLING BLVD
Row 3 Phone: (941) 954-5536
Row 1 GEORGE DESPINA CPA APALACHICOLA FL 32320
Row 2 99 MARKET ST
Row 3 Phone: (850) 653-2770
Row 1 GEORGE F CPA PA TALLAHASSEE FL 32308
Row 2 1708 METROPOLITAN BLVD
Row 3 Phone: (850) 385-112
 
Top