Reformatting Text to Excel

Originally Posted by Joker

Does anyone have an easier way to move data from a text file to Excel,
rather than manually adjusting each line. Here is a sample of the data:

Card Name: Woodwraith Strangler

Cost: 2BG

Type: Creature — Plant Zombie

Pow/Tgh: 2/2

Rules Text: Remove a creature card in your graveyard from the game:

Regenerate Woodwraith Strangler.

Set/Rarity: Ravnica: City of Guilds common





Card Name: Zephyr Spirit

Cost: 5U

Type: Creature — Spirit

Pow/Tgh: 0/6

Rules Text: When Zephyr Spirit blocks, return it to its owner’s

hand.

Set/Rarity: Ravnica: City of Guilds common



I would like each of the heading to be a column heading rather than row.
Any ideas?
--
Joker
"...God hath made me to laugh, so that all that hear will laugh with me."
Gen. 21:6

Hi Joker

Select the data and in a new cell that doesn't overlap any previous, or ideally a new worksheet, copy paste special and tick the transpose box