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
|