I have a template which I have created in Excell which has now been populated with information.
The template is a list of individuals with corresponding descriptions, comments, and budget figures.
There are 6 rows for each individual.
My goal is to remformat the content into one logical row of data for each individual( ID# - September Budget %) that I can then import into an access database.
For the columns "Projects" (K) and "Comments" (L) that may have 6 individual rows of data, I would like to string the comments together and Ideally have them combined into one cell.
For columns S- AE (The Forcast section of the template) I would like it to be formated in the one row as "Opex Budget %" followed the 12 figures for each month (S:6 AE:6) , then "Capex Budget %" followed by the 12 figures for each month (S:8 AE:8)
I have attached a mock version of the template with filler data for the first few resources.
Is it possible to accomplish this through using some VBA code to reformat the template?
If the hidden columns M-Q create any difficulty they can be deleted.