I have a sheet with approx 6000 lines, as parsed from a wordsheet downloaded from an old fashioned software. Column B differentiates the different groups (fields) of data. e.g. Field 1 label is in cell B1, Field 2 label is in cell B32, Field 3 label is in cell B87.
Cells B2 to B31 are blank, Columns C,D, and E, F, G, H contain data for Field 1 which I want to associate with the Field 1 label in B1.
Likewise I want to associate Field labels 2 and 3 to their corresponding data in Columns C,D,E,F, G and H
Unfortunately, I am not an excel expert but have been limiting myself to IF functions to try replace the blank label fields in B, with little luck.
Help would be appreciated
Cells B2 to B31 are blank, Columns C,D, and E, F, G, H contain data for Field 1 which I want to associate with the Field 1 label in B1.
Likewise I want to associate Field labels 2 and 3 to their corresponding data in Columns C,D,E,F, G and H
Unfortunately, I am not an excel expert but have been limiting myself to IF functions to try replace the blank label fields in B, with little luck.
Help would be appreciated