move cells data

[BillyKit]

Hi everyone,

I have tables like shown below. The table consists of summary data in one row followed by the details below the row. Can anybody help to write a macro to move the details data to the cells as shown and delete the blank rows.
Thank you

 

[texasalynn]

can't see the table

 

[BillyKit]

can't see the table

I am sorry for the missing image.I'll repost my question.The table consists of rows of summary data determined by column A as in A2 and followed by one or more rows of details data below it. I need help to write a macro to move the details data to the summary row as in

C3 to D2, E3 to F2, G3 to H2, I3 to J2
C5 and c6 to D4 AND D6 respectively and so...

 

[BillyKit]

Re: macro to move cells data

I posted this question earlier but somehow the image of sample data I link to did not appear.I have repost the question and hope someone will be able to help me.The table shown below contains rows of summary data determined by column A as in A2 and A4and followed by one or more rows of details data below it. The sheet may up to a thousand rows. I need help to write a macro to move the details data to the summary row as like

C3 to D2, E3 to F2, G3 to H2, I3 to J2
C5 and c6 to D4 AND D6 respectively and so on...

Thank you

 

[BillyKit]

Hi, can somebody help?

 

[texasalynn]

your first line of data shows a pattern but the second line doesn't, so I'm unable to help. And your table has never been shown only a "x" box. Try using the Jeanie to show your data
http://www.excel-jeanie-html.de/index.php?f=1

 

[BillyKit]

your first line of data shows a pattern but the second line doesn't, so I'm unable to help. And your table has never been shown only a "x" box. Try using the Jeanie to show your data
http://www.excel-jeanie-html.de/index.php?f=1

Hi, thank you for replying.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	Date		Qty	Item	Amount	Sku	Place	Qty1	Mode	Amount1
2	17-Dec-09		1		1.99		Loc1		Cash
3			123456		xxxxxxxxxx001		1		1.99
4	19-Dec-09		2		20		Loc2		Visa
5			111112		xxxxxxxxxx002		1		10
6			111113		xxxxxxxxxx003		1		10
7	20-Dec-09
Sheet1