Moving data from columns into rows

Closed
Terry - Jul 24, 2010 at 07:26 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jul 26, 2010 at 08:10 AM
Hello,

I have data that is in two rows in excel such as this:

3/1/09 Joe Sick John Black hotdog 47 y/o
ID # 123-09-6383 bun
All this data refers to one record. I want this one record to be moved to one row

3/1/09 Joe Sick John Black hot dog 47y/o ID# 123-09-6383 bun

After moving, I want the macro to delete the rows in between, advance to the next record, and move the data. Can this be done. I am very new to macros, just learned about them in an Access class. The final record should look like:

3/1/09 Joe Sick John Black hot dog 47y/o ID# 123-09-6383 bun
3/1/09 Gwen Hi Joe better stew 85y/o ID# 937-84-8353 soda

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jul 26, 2010 at 08:10 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0