Hi All,
I need help creating a macro to insert some rows depending on whether or not there are values in columns C to I and tranpose them into the new rows. I also need the values in the ID column to be copied for each additional row created. I hope the example data below gives you guys a better idea.
Thank you so much!
------------------------
Current spreadsheet:
ID Market
1 House Residential Office Cliff
2 Cliff
3
4 Office Residential
5 Cliff
6 House
7
8 Medical Office Store
--------------------
Desired outcome:
1 House
1 Residential
1 Office
1 Cliff
2 Cliff
3
4 Office
4 Residential
5 Cliff
6 House
7
8 Medical
8 Office
8 Store
Bookmarks