I have copied and pasted a table from the internet into a spreadsheet and am having trouble reformatting the data nicely.
The data are listed as follows:
I would like to reformat it to look like this
Where g1- indicates it belongs in group 1 and g2- indicates it belongs in group 2. For each group, column A could contain 4-6 rows and column D could contain 1-3 rows. There are roughly 42,000 rows in my sheet, so doing things manually is really not an option. Luckily, the start of a new group is indicated by bold formatting. Meaning, A1 and A6 would both be bold.
Do you have any suggestions on how to set this up in VBA? If the groups were separated by a blank row, I could figure it out, but not separated by formatting, so I am at a loss.
I have attached a sample spreadsheet for any clarification.
Bookmarks