Need to create rows from columns

  • Thread starter Thread starter patc303
  • Start date Start date
P

patc303

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
 
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.
 
Back
Top