Moving data from columns into rows

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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