M
maacmaac
I have ~50,000 rows of data that I need to analyze/format for easier
viewing. I want to create boxes/lines around data for each unique name
in a column. I have data in Column B. Everytime the name changes, I
want to create a new box and I also would like to Merge the cells if
possible. I am trying to write a Macro using a loop function but
having no luck. See attached spreadsheet for Raw Data and the desired
result is going to be.
+-------------------------------------------------------------------+
|Filename: Format Table.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3894 |
+-------------------------------------------------------------------+
viewing. I want to create boxes/lines around data for each unique name
in a column. I have data in Column B. Everytime the name changes, I
want to create a new box and I also would like to Merge the cells if
possible. I am trying to write a Macro using a loop function but
having no luck. See attached spreadsheet for Raw Data and the desired
result is going to be.
+-------------------------------------------------------------------+
|Filename: Format Table.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3894 |
+-------------------------------------------------------------------+