I am trying to get my data out of one horrible database and ready for data
migration into a decent one. However, when I extract it, the data ends up on
separate rows, instead of in columns:

Matter No.
IN001
Brand
Merchandise
Agent
Block Partners Inc.

How can I get my data to read across instead of down? I've tried exporting
into html, txt, csv, etc, but it's even messier. Assuming Excel is the best
way to get my data out, are there any Excel formulas I can use to reorder my
data? Any help would be much appreciated!