# Need to get data from different cell numbers

Closed
Bobby - Jun 2, 2009 at 08:08 AM
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
- Jun 4, 2009 at 05:39 AM
Hello,

I have a list of invoices (hundreds) downloaded from some software into excel format. The downloaded data however lists invoice data as follows, occupying two rows.

123 GLOP968
5/21/2009 \$1,206.58

In the above example: Invoice No 123 is in cell A1, Invoice Date 5/21/09 is in cell A2, Vendor Code GLOP968 is in cell B1, and Invoice Amount \$1206.58 is in cell B2.

Now, is there a formula that I can use to transfer all this data in a new sheet showing data as follows:

Invoice No 123 is in cell A2, Invoice Date 5/21/09 in cell B2, Vendor Code: GLOP968 in cell C2, and Invoice Amount \$1206.58 in cell D2.

Thank you and best regards,

Bobby

## 4 replies

mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
159
Jun 3, 2009 at 12:14 AM
In you sheet2 in Row2 put these formulas

A2=Sheet1!A1
B2=Sheet1!A2
C2=Sheet1!B1
D2=Sheet1!B2

Now in Column E3 write 2
E3=2
E4=4
E5=6
.
.
give increment of 2 continuously
.
.
.
Now in Row 3 write below formula
A3=INDIRECT("Sheet1!A"&1+E3)
B3=INDIRECT("Sheet1!A"&2+E3)
C3=INDIRECT("Sheet1!B"&1+E3)
D3=INDIRECT("Sheet1!B"&2+E3)

Now Drag your These 4 cells downward ....
your all cells from sheet1 will be occurred as per your wish ......

frank_einstein
Posts
7
Registration date
Thursday January 1, 2009
Status
Member
Last seen
June 8, 2009
2
Jun 3, 2009 at 02:06 AM
thanks or your support to this forum mubashir
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
159
Jun 3, 2009 at 02:27 AM
@ Frank, you alwaz welcome ....

Waiting for Vote :)

wow! that's brilliant!
thank you very much Mubashir. ;)
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
159
Jun 4, 2009 at 05:39 AM
@ Boby, enjoy it ....

Waiting for Vote :)