Facing some difficulty with formatting data in MS Excel

Microsoft Excel 2010 - complete product...
March 5, 2013 at 09:48:02
Specs: Windows 7
Hi I have problem, I have data that looks like:
A B C D E F G
1 Name Date Amount Date Amount Date Amount
And i Want them to appear like:
A B C
1 Name Date Amount
2 (same name) Date Amount
3 (same name) Date Amount

Please help!


See More: Facing some difficulty with formatting data in MS Excel

Report •

#1
March 5, 2013 at 14:06:51
Please click on the following line and read the instructions on how to post data in this forum, then repost your data so that we can see how it lines up. Thanks.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
March 5, 2013 at 15:39:56
Hi I have problem, I have data that looks like:
 
            A       B      C      D       E       F       G
      1 Name      Date   Amount   Date   Amount   Date    Amount
And i Want them to appear like:
            A         B      C
1    Name           Date   Amount
2    (same name)    Date   Amount
3    (same name)    Date   Amount

Please help!
There are thousands of records like these.

Report •
Related Solutions


Ask Question