Need to create rows from columns
 

I have a spreadsheet that looks like this:

Name | item 1 | item 2 | item 3 (etc.)

I need to format it into:

Name | item 1
Name | item 2
Name | item 3

Does anyone know how I can do that?
Thank you -
Pat

Need to create rows from columns
 

Transfer everything to a second sheet.
A B
1 Name 1
2 Name 2
3 Name 3

Use this for A1
=Sheet1!$A$1
and this for B1
=INDEX(Sheet1!$B$1:$D$1,ROW())

Both formulas can be copied down

When done, Copy | Paste Special - Values and you will have a reformatted
sheet of data.

Expand the $B$1:$D$1 as needed for your data.


--
If this helps, please remember to click yes.


"patc303" wrote:

I have a spreadsheet that looks like this:

Name | item 1 | item 2 | item 3 (etc.)

I need to format it into:

Name | item 1
Name | item 2
Name | item 3

Does anyone know how I can do that?
Thank you -
Pat