Change Data from Columns to Rows

I want to create a macro that takes data that has the following columns like this:

Category Heading Price Description

and formats into a new worksheet like this:


Category A

Heading A Price A
Description A

Heading B Price B
Description B

Category B

Heading C Price C
Description C

etc.

The goal is to get an output that would be easily paste-able as text and an easy to read text based catalog of sorts from raw data.

Is this something that is a newbie macro person can tackle? If so, how would I get started?

thanks in advance....Matt