Moving Row Data to Column/Row Groups

  • Thread starter Thread starter AdGuy
  • Start date Start date
A

AdGuy

First off...great forum with super smart participants. Hopefully, I ca
tap into some of this brain power!! :) I have received an Excel emai
spreadsheet containing hundreds of names and corresponding emai
addresses. Problem is the data runs on one line from A1 to GB1. Fo
example,

A1 B1 C1 D1 E1 F1, etc
(name 1)(email 1)(name 2)(email 2)(name 3)(email 3) etc.

I need to break the data to a two column format with the first colum
containing the name and the second column containing the emai
address...then dropping down to the next row and listing the next set
then the next and so on. The good news is the pattern (name, email
name, email) is continuous.

Any ideas
 
Hi
on a second sheet enter the following formula in cell A1
=OFFSET('sheet1'!$A$1,0,(ROW()-1)*2+COLUMN()-1)
and copy this formula down and to the right
 
Back
Top