Need to get data from different cell numbers

[Closed]
Report
-
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
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

Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
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 ......




2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
7
Registration date
Thursday January 1, 2009
Status
Member
Last seen
June 8, 2009
2
thanks or your support to this forum mubashir
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
@ Frank, you alwaz welcome ....

Waiting for Vote :)

wow! that's brilliant!
thank you very much Mubashir. ;)
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
@ Boby, enjoy it ....

Waiting for Vote :)