MS Excel 2007 Is there a way to do this?

[Linflas]

I have a list of bar code data I scanned in with my phone to import into Excel. What I now have is an alternating list of tag #'s and serial numbers that I need to get next to one another.

Example:
A
1 123456
2 ABC789DE
3 789123
4 DEF123FG

and so on and what I want to end up with is:
A B
1 123456 ABC789DE
2 789123 DEF123FG

 

[sm625]

With 1 in A1, and 123456 in B1, and 2 in A2, etc

Use the following formula in cell H1: =OFFSET(Sheet1!$B$1,(A1-1)*2,0)
and use this formula in I1: =OFFSET(Sheet1!$B$1,(A1-1)*2+1,0)

Then do a fill down for columns H and I

 

[Linflas]

Thanks I'll try this Monday.